Dropping a customer, activity-based costing, ethics. Justin Anders is the
Sales | $43,680 |
Cost of goods sold (all variable) | 26,180 |
Order processing (50 orders processed at $280 per order) | 14,000 |
Delivery (5,000 miles driven at $0.70 per mile) | 3,500 |
Rush orders (6 rush orders at $154 per rush order) | 924 |
Customer sales visits (6 sales calls at $140 per call) | 840 |
Total costs | 45,444 |
Profits | $(1,764) |
Sara looks at the report and remarks, “I’m glad to see all my hard work is paying off with Donnelly’s. Sales have gone up 10% over the previous quarter!”
Justin replies, ‘Increased sales are great, but I’m worried about Donnelly’s margin, Sara. We were showing a profit with Donnelly’s at the lower sales level, but now we’re showing a loss. Gross margin percentage this quarter was 40%, down five percentage points from the prior quarter I’m afraid that corporate will push hard to drop them as a customer if things don’t turn around.”
“That’s crazy,” Sara responds. “A lot of that
- 1. Assume that Sara is partly correct in her assessment of the report. Upon further investigation, it is determined that 10% of the order
processing costs and 20% of the delivery costs would not be avoidable if CRS were to drop Donnelly’s. Would CRS benefit from dropping Donnelly’s? Show your calculations. - 2. Sara’s bonus is based on meeting sales targets. Based on the preceding information regarding gross margin percentage, what might Sara have done last quarter to meet her target and receive her bonus? How might CRS revise its bonus system to address this?
- 3. Should Justin rework the numbers? How should he respond to Sara’s comments about making Donnelly’s look more profitable?
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- Product Profitability Analysis Galaxy Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVS), the Conquistador and Hurricane, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Conquistador Hurricane Sales price $4,800 $3,200 Variable cost of goods sold (3,020) (2,140) Manufacturing margin $1,780 $1,060 Variable selling expenses (964) (548) Contribution margin $816 $512 Fixed expenses (380) (200) Operating income $436 $312 In addition, the following sales unit volume information for the period is as follows: Conquistador 2,800 Hurricane 2,000 Sales unit volume a. Prepare a contribution margin by product report. Compute the contribution margin ratjo for each product as a whole percent. Galaxy Sports Inc. Contribution Margin by Productarrow_forwardProblem 1. Mahinahon Company would like to institute an activity-based costing system to price products. The company's Purchasing Department incurs costs of P550,000 per year and has six employees. Purchasing has determined the three major activities that occur during the year. Activity Allocation Measure # of People Total Cost Issuing purchase orders # of purchase orders 1 P285,000 Reviewing receiving reports # of receiving reports 2 P190,000 Making phone calls # of phone calls 3 P220,000 During the year, 50,000 phone calls were made in the department; 15,000 purchase orders were issued; and 10,000 shipments were received. Product A required 200 phone calls, 150 receiving reports, and 50 purchase orders. Product B required 350 phone calls, 400 receiving reports, and 100 purchase orders. 1Determine the amount of purchasing department cost that should be assigned to each of these products. 1.2. Determine purchasing department cost per…arrow_forwardPlease provide correct answer with this problemarrow_forward
- Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardAssign the customer-related activity costs to each customer type using activity rates. Now calculate the profitability of each customer category. As a manager, how would you use this information? Emery Company sells small machine parts to heavy equipment manufacturers for an average price of 1.05 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plants manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customers specifications have been met Inspection takes essentially the same time regardless of the type of part being produced. Emerys Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Calculate the profitability of each customer type. Discuss the problems with this measure of customer profitability.arrow_forwardNote that Barbaras Bistro in Figure 1-2 prepares monthly performance reports. Do you think that it would be a good idea for Barbara to switch to just an annual performance report in an effort to reduce its accounting costs?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_forwardThe following information is from Daves Sporting Goods. Daves is a Midwest sporting goods store with three regional stores. The August income statement for all stores is shown. A. Comment on the operating income results for each store. B. Now assume the costs allocated from corporate is an uncontrollable cost for each store. How does this change your assessment of each store?arrow_forwardIdentifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent situations: a. A computer service agreement in which a company pays 150 per month and 15 per hour of technical time b. Fuel cost of the companys fleet of motor vehicles c. The cost of beer for a bar d. The cost of computer printers and copiers at your college e. Rent for a dental office f. The salary of a receptionist in a law firm g. The wages of counter help in a fast-food restaurant h. The salaries of dental hygienists in a three-dentist office. One hygienist can take care of 120 cleanings per month. i. Electricity cost which includes a 15 per month billing charge and an additional amount depending on the number of kilowatt-hours used Required: 1. For each situation, describe the cost as one of the following: fixed cost, variable cost, mixed cost, or step cost. (Hint: First, consider what the driver or output measure is. If additional assumptions are necessary to support your cost type decision, be sure to write them down.) Example: Raw materials used in productionVariable cost 2. CONCEPTUAL CONNECTION Change your assumption(s) for each situation so that the cost type changes to a different cost type. List the new cost type and the changed assumption(s) that gave rise to it. Example: Raw materials used in production. Changed assumptionthe materials are difficult to obtain, and a years worth must be contracted for in advance. Now, this is a fixed cost. (This is the case with diamond sales by DeBeers Inc. to its sightholders. See the following website for information: www.keyguide.net/sightholders/.)arrow_forward
- The Chocolate Baker specializes in chocolate baked goods. The firm has long assessed the profitability of a product line by comparing revenues to the cost of goods sold. However, Barry White, the firms new accountant, wants to use an activity-based costing system that takes into consideration the cost of the delivery person. Following are activity and cost information relating to two of Chocolate Bakers major products: Using activity-based costing, which of the following statements is correct? a. The muffins are 2,000 more profitable. b. The cheesecakes are 75 more profitable. c. The muffins are 1,925 more profitable. d. The muffins have a higher profitability as a percentage of sales and, therefore, are more advantageous.arrow_forwardEvaluating selling and administrative cost allocations Gordon Gecco Furniture Company has two major product lines with the following characteristics: Commercial office furniture: Few large orders, little advertising support, shipments in full truckloads, and low handling complexity Home office furniture: Many small orders, large advertising support, shipments in partial truckloads, and high handling complexity The company produced the following profitability report for management: The selling and administrative expenses are allocated to the products on the basis of relative sales dollars. Evaluate the accuracy of this report and recommend an alternative approach.arrow_forwardWest Island distributes a single product. The companys sales and expenses for the month of June are shown. Using the information presented, answer these questions: A. What is the break-even point in units sold and dollar sales? B. What is the total contribution margin at the break-even point? C. If West Island wants to earn a profit of $21,000, how many units would they have to sell? D. Prepare a contribution margin income statement that reflects sales necessary to achieve the target profit.arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning