Posted: April 12th, 2023

Ray Panneton, president of Okus Designs

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.align="left">align="right">align="right">align="right">align="right">align="right">CustomerRevenuesCost of SalesSelling CostsCustomer Net ProfitCustomer Profit MarginMeredith's Boutique$ 5,000,000$ 3,750,000$ 750,000500,00010.00%Stewart Industries4,890,0003,618,600978,000293,4006.00%T&P Incorporated4,500,0003,375,0001,129,500(4,500)(0.10%)Talley Design Studios4,200,0003,192,000378,000630,00015.00%UPPtown Productions4,100,0002,870,000902,000328,0008.00%O'Brien's Tavern3,900,0002,730,0001,365,000(195,000)(5.00%)House of Claire3,850,0002,887,500885,50077,0002.00%Copper Metalworks3,700,0002,664,000888,000148,0004.00%J Floral Designs3,625,0002,501,2501,486,250(362,500)(10.00%)Old Main Masonry3,500,0002,485,000770,000245,0007.00%Total/Average$41,265,000$30,073,350$9,532,2501,659,4004.02%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 Ray take?

Tags: Ace My Homework: Essay Help, Assignment Help: USA's #1 Online Assignment Writing Service, Do My Assignment for Me Online - Write Academic Papers, Reliable Online Homework Help For You