Customer profitability in a manufacturing firm. Mississippi Manufacturing makes a component called B2040. This component is manufactured only when ordered by a customer, so Mississippi keeps no inventory of B2040. The list price is $112 per unit, but customers who place “large” orders receive a 10% discount on price. The customers are manufacturing firms. Currently, the salespeople decide whether an order is large enough to qualify for the discount. When the product is finished, it is packed in cases of 10. If the component needs to be exchanged or repaired, customers can come back within 14 days for free exchange or repair.
The full cost of manufacturing a unit of B2040 is $95. In addition, Mississippi incurs customer-level costs. Customer-level cost-driver rates are:
Order taking | $360 per order |
Product handling | $15 per case |
Rush-order processing | $560 per rush order |
Exchange and repair costs | $50 per unit |
Information about Mississippi’s five biggest customers follows:
All customers except E ordered units in the same order size. Customer E’s order quantity varied, so E got a discount part of the time but not all the time.
- 1. Calculate the customer-level operating income for these five customers. Use the format in Figure 14-3. Prepare a customer-profitability analysis by ranking the customers from most to least profitable, as in Figure 14-4.
Required
Required
- 2. Discuss the results of your customer-profitability analysis. Does Mississippi have unprofitable customers? Is there anything Mississippi should do differently with its five customers?
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- Many different businesses employ markup on cost to arrive at a price. For each of the following situations, explain what the markup covers and why it is the amount that it is. a. Department stores have a markup of 100 percent of purchase cost. b. Jewelry stores charge anywhere from 100 percent to 300 percent of the cost of the jewelry. (The 300 percent markup is referred to as keystone.) c. Johnson Construction Company charges 12 percent on direct materials, direct labor, and subcontracting costs. d. Hamilton Auto Repair charges customers for direct materials and direct labor. Customers are charged 45 per direct labor hour worked on their job; however, the employees actually cost Hamilton 15 per hour.arrow_forwardMake or Buy - Home Grocery (HG) provides home delivery of groceries. Customers submit orders to the HG website by selecting the needed items from a menu. Currently, HG has employees who deliver the groceries, but the company is considering the option of contracting out deliveries. The fixed cost of the grocery delivery operation is $500,000 per year, of which, $200,000 is avoidable if grocery deliveries are contracted out. A statistical study suggests delivery costs vary with both the number of customers and the number of items purchased. On average, the fixed annual delivery cost per customer is $250 and the average variable delivery cost of each grocery item delivered is $0.50. On average, each customer purchases 1,000 grocery items per year. Therefore, if there are 2,000 customers budgeted, the number of grocery item deliveries will be 2 million. Custom delivery (CD) has offered to deliver groceries for HG as a flat rate of $850 per customer per year irrespective of the number of…arrow_forwardHomoward Hardware buys cat liter for $6 less 20% per bag. The store's overhead is 45% of cost and the owner requires a profit of 20% of cost (a) (b) (c) (d) (e) (7) For how much should the bags be sold? What is the amount of markup included in the selling price? What is the rate of markup based on selling price? What is the rate of markup based on cost? What is the break-even price? What operating profit or loss is made if a bag is sold for $7 509arrow_forward
- EOQ for a retailer. The Cloth Center sells fabrics to a wide range of industrial and consumer users. One of the products it carries is denim cloth, used in the manufacture of jeans and carrying bags. The supplier for the denim cloth pays all incoming freight. No incoming inspection of the denim is necessary because the supplier has a track record of delivering high-quality merchandise. The purchasing officer of the Cloth Center has collected the following information: Annual demand for denim cloth 20,000 yards Ordering cost per purchase order P160 Carrying cost per year 20% of purchase costs Safety-stock requirements None Cost of denim cloth P8 per year The purchasing lead time is 2 weeks. The Cloth Center is open 250 days a year (50 weeks for 5 days a week).1. Calculate the EOQ for denim cloth.2. Calculate the number of orders that will be placed each year3. Calculate the reorder point for denimcloth.arrow_forwardColumbus Inc. sells a high end hair dryer in a super competitive marketplace. As a result, market research and competitive pressures influence the determination of their selling price. Their marketing department has done a comprehensive analysis and It looks like a price of $57 would be appropriate given the present business environment. The company has a goal of earning $28 on each unit. What is the target unit cost of each hair dryer? Enter your answers without dollar signs or commas.arrow_forwardCompany XYZ is specialized in producing and selling smart watches. The company currently has two products and is planning to improve it profits in the coming years. The company is thinking of introducing a sales commission to encourage its sales people to make more sales and improve company's profitability. When designing the sales commission the company should base the sales commission on: O a. The color of the product Ob. None of the given answers O C. The number of employees O d. The selling price O e. The contribution marginarrow_forward
- Required information [The following information applies to the questions displayed below.] Hult Games buys electronic components for manufacturing from two suppliers, Milan Components and Dundee Parts. If the components are delivered late, the shipment to the customer is delayed. Delayed shipments lead to contractual penalties that call for Hult to reimburse a portion of the purchase price to the customer. During the past quarter, the purchasing and delivery data for the two suppliers showed the following. Dundee 48,000 28 40 10% Total purchases (cartons) Average purchase price (per carton) Number of deliveries Percentage of late deliveries Milan Dundee Milan 112,000 $ 26.00 60 25% Effective Cost Per Carton $ Total 160,000 $ 26.60 100 The Accounting Department recorded $492,000 as the cost of late deliveries to customers. 19% Required: Assume that the average quality, measured by the percentage of late deliveries, and prices from the two companies will continue as in the past. What is…arrow_forwardDough, Re, Mi Inc. sells many different types of cookie dough. The company is deciding whether to continue making its own dough or to outsource. If the company outsources, they will eliminate all of the variable overhead and 30% of the fixed manufacturing overhead. Use the information below to determine whether Dough, Re, Mi Inc. should outsource or not. Data: Units Per unit Relevant? Yes or No Sales price (per unit) 5,450 $ 104.00 Direct materials (per unit) N/A 21.00 Direct labor (per unit) N/A 18.00 Variable manufacturing overhead (per unit) N/A 15.00 Fixed manufacturing overhead (MOH) (per month) : N/A 21.00 Avoidable fixed MOH (per month) N/A Unavoidable fixed MOH (per month) N/A Sales commissions (per unit) N/A 4.00 Advertising costs (per month) N/A 1.60…arrow_forwardBradley Nowell works as a purchaser at Louie Dog Industries. He is in charge of purchasing dog beds from manufacturers. Bradley's mother, seeing an opportunity, starts a dog bed manufacturing company and quickly receives almost all of Louie Dog's orders. In order to fill the orders, Bradley's mother buys low-quality beds from another dog bed supplier and sells those to Louie Dog for a substantial markup. In fact, the price charged to Louie Dog is twice what other manufactures would charge the company. What type of scheme is this? Pay-and-return Non-accomplice vendor Pass-through Inventory-markuparrow_forward
- Finn Enterprises manufactures ceiling fans that normally sell for $92 each. There are 320 defective fans in inventory, which cost $60 each to manufacture. These defective units can be sold as is for $20 each, or they can be processed further for a cost of $42 each and then sold for the normal selling price. Stooge Enterprises would be better off by a OA $23,040 not increase in operating income if the ceiling fans are repaired. OB. $9.600 net increase in operating income if the ceiling fans are repaired OC. $23,040 net increase in operating income if the ceiling fans are sold as is OD. $9,600 net increase in operating income if the ceiling fans are sold as is.arrow_forwardQ1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most popular model of couch varies depending on how many they purchase for sale. For the first 200 couches the cost is $299 each; for the next 200 couches it drops to $250 each; and for every couch after that it costs $225. Create an excel function using the IF function to show the gross profit under the following scenarios: a. b. It sells at a price of $650 and 350 units are purchased for sale and sold It sells at a price of $625 and 300 units are purchased for sale and sold It sells at a price are $700 and 1,000 units are purchased for sale and sold C.arrow_forwardA furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $250 to profit, and a chair contributes $145. Marketing restrictions require that the number of chairs produced be at least four times the number of desks produced. There are 2,000 units of wood available. Use Solver to maximize the company's profit. a. What is the optimized company's profit? Use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 1,000 to 3,000 in 100-unit increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2,000 units? How much profit would the company lose if it lost any of its current 2,000 units? Round the answer to a whole dollar amount.arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning