Ray Panneton, president of Okus Designs, met with his CFO and vice president of marketing to discuss the profitability of the company’s top 10 customers. These customers account for 80% of the company’s revenues. The following table was prepared by the accounting department to assist Ray in his decision making.

Required

a. Ray is concerned about the customers with negative customer profit margins. If these customers are dropped, what will be the new total customer net profit and customer profit margin (assume the cost of sales and selling costs can be eliminated)?
b. Ray is also concerned about customers with customer profit margins below the current company average. If all customers with below-average profit margins are dropped, what will be the new total customer net profit and customer profit margin (assume the cost of sales and selling costs can be eliminated)?
c. Compare your answers to parts (a) and (b). What do you notice?
d. If Ray were to drop all customers with profit margins below average, how much in new customer revenues would need to be added to make the company as well off as it would be if it only dropped the customers with negative profit margins? Use an average profit margin for the new customers equal to the one you calculated in part (a).
e. What action do you recommend Raytake?

Transcribed Image Text:

Cost of Sales Selling Costs Customer Net Profit Customer Profit Margin 10.00% 6000% (0.1 0%) 15.00% Customer Revenues Meredith's Boutique 5,000,000 4,890,000 4,500,000 Talley Design Studios 4,200,000 UPPtown Productions 4,100,000 3,900,000 3,850,000 Copper Metalworks 3,700,000 3,625,000 3,500,000 $41,265,000 $ 3,750,000 750,000 978,000 1,129,500 378,000 902,000 1,365,000 885,500 888,000 1,486,250 770,000 $30,073,350 9,532,250 500,000 293,400 (4,500) 630,000 328,000 (195,000) 77,000 148,000 (362,500) 245,000 1,659,400 Stewart Industries T&P Incorporated 3,618,600 3,375,000 3,192,000 2,870,000 2,730,000 2,887,500 2,664,000 2,501,250 2,485,000 O'Brien's Tavern House of Claire 500%) 400% (10.00%) 7.00% 4.02% J Floral Designs Old Main Masonry Total/Average