Exercise 9-45 (Algo) Activity-Based Costing in a Service Environment (LO 9-3, 4, 5)
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 39,000 hours last year, 25,000 on residential jobs and 14,000 on commercial jobs. Wages were $15 per hour for all work done. Any materials used are included in
Required:
a. If overhead for the year was $125,550, what were the profits of the residential and commercial services using labor-hours as the allocation base? (Do not round intermediate calculations. Round final answers to the nearest whole dollar.)
b. Overhead consists of costs of traveling to the site, using equipment (including vehicle rental), and using supplies, which can be traced as follows.
Cost Driver Volume |
||||||||||
Activity | Cost Driver | Cost | Commercial | Residential | ||||||
Traveling | Number of clients served | $ | 15,000 | 15 | 45 | |||||
Using equipment | Equipment hours | 37,050 | 3,800 | 1,900 | ||||||
Using supplies | Area serviced in square yards | 73,500 | 120,000 | 90,000 | ||||||
Total overhead | $ | 125,550 | ||||||||
Recalculate profits for commercial and residential services based on these activity bases. (Do not round intermediate calculations. Round final answers to the nearest whole dollar.)
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 3 images
- Please do not give solution in image format thankuarrow_forward! Required information [The following information applies to the questions displayed below.] Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company Net operating income increase $ 463,500 231,750 231,750 129,780 101,970 64,890 $ 37,080 100.00% 50.00% 50.00% 28.00% 22.00% 14.00% 8.00% Chicago $ 154,500 46,350 108,150 80, 340 $ 27,810 Office 100.00% 30.00% 70.00% 52.00% 18.00% Minneapolis $ 309,000 185,400 123,600 49,440 $ 74,160 100.00% 60.00% 40.00% 16.00% 24.00% 2. By how much would the company's net operating income increase…arrow_forwardPlease solve this problemarrow_forward
- Please do not give solution in image format thankuarrow_forward[The following information applies to the questions displayed below.] Jorgansen Lighting, Incorporated, manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data: Year 1 Year 2 Year 3 Inventories Beginning (units) 210 160 180 Ending (units ) 160 180 230 Variable costing net operating income $300,000 $ 279,000 $ 260,000 The company's fixed manufacturing overhead per unit was constant at $560 for all three years. Required: 1. Calculate each year's absorption costing net operating income. Note: Enter any losses or deductions as a negative value.arrow_forward! Required information Self-Study Problem 11-2 (Algo) The Make-vs.-Buy Decision [The following information applies to the questions displayed below.] Highvalu Incorporated manufactures a moderately priced set of lawn furniture (a table and four chairs) that it sells for $320. The company currently manufactures and sells 7,900 sets per year. The manufacturing costs include $104 for direct materials and $64 for direct labor per set. The overhead charge per set is $54, which consists entirely of fixed costs. Assume that Highvalu currently purchases the chair cushions for its lawn set from an outside vendor for $21 per set. HighValu's chief operations officer wants an analysis of the comparative costs of manufacturing these cushions to determine whether bringing the manufacturing in-house would save the company money. Additional information shows that if HighValu were to manufacture the cushions, the direct materials cost would be $8 and the direct labor cost would be $6 per set. In…arrow_forward
- Hello tutor solve this problem questionarrow_forwardPlease do not give solution in image format thankuarrow_forwardOutsourcing (Make-or-Buy) Decision Mountain Air Limited manufactures a line of room air purifiers. Management is currently evaluating the possible production of an air purifier for automobiles. Based on an annual volume of 10,000 units, the predicted cost per unit of an auto air purifier follows. Direct materials $9.00 Direct labor 1.40 Factory overhead 10.00 Total $ 20.40 These cost predictions include $80,000 in fixed factory overhead averaged over 10,000 units. The completed air purifier units include a battery-operated electric motor, which Mountain Air assembles with parts purchased from an outside vendar for $2.00 per motor. Mini Motor Company has offered to supply an assembled battery operated motor at a cost of $5.50 per unit, with a minimum annual order of 5,000 units. If Mountain Air accepts this offer, it will be able to reduce the variable labor and variable overhead casts of the auto air purifier by 50 percent. (a) Determine whether Mountain Air should continue to make the…arrow_forward
- Required information [The following information applies to the questions displayed below.] Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Office Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating income i Total Company $ 495,000 247,500 247,500 138,600 108,900 69,300 $ 39,600 100.00% 50.00% 50.00% 28.00% 22.008 14.00% 8.00% Chicago $ 165,000 49,500 115,500 85,800 $ 29,700 100.00% 30.00% 70.00% 52.00 18.00% Minneapolis $ 330,000 198,000 132,000 52,800 $ 79,200 100.00% 60.00% 40.00% 16.00 24.00% 3. Assume that sales in Chicago increase by $55,000 next year and that sales in Minneapolis remain…arrow_forwardHow do I determine the company's total contribution margin, contribution margin per service call, and contribution margin ratio when 50 service calls are made in the month of June? Problem E21-23arrow_forwardExtreme Sports sells logo sports merchandise. The company is contemplating whether or not to continue its custom embroidery service. All of the company's direct fixed costs can be avoided if a segment is dropped. The information is available for the segments. Custom Logo Embroidery Apparel Sales $59,000 $250,000 Variable costs 30,000 109,000 Contribution margin $29,000 $141,000 Direct fixed costs 22,000 39,000 Allocated common fixed costs 12,000 50,000 Net income $(5,000) $52,000 A. What will be the impact on net income if the embroidery segment is dropped? Net income $ Decrease B. Assume that if the embroidery segment is dropped, apparel sales will increase 10%. What is the impact on the contribution margin and net income solely for the apparel? Contribution margin $ Increase Net income Increase C. Identify one cost that is not relevant in this analysis. Common fixed costsarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education