Customer Profitability

The following gives sales, product costs, and cost to serve data for a company that makes three product lines A, B, and C. The company has two customer types.

	Product A	Product B	Product C
Sales	$5,000	$6,000	$25,000
Cost of sales	4,500	4,800	15,000
	Customer Type 1	Customer Type 2	Total
Product A Sales	$500	$4,500	$5,000
Product B Sales	1,000	5,000	6,000
Product C Sales	13,000	12,000	25,000
Manager Visits	4	16	20

The cost to serve all customers is $12,000 and is allocated to customer type based on the number of manager visits to customer locations for pre and post sales support.

1. Determine the gross profit margin percentage of sales for each product. Which product is the most profitable.

2. Determine the gross profit margin and the gross profit margin percentage of sales for each customer type.

3. Determine the cost-to-serve percentage of sales for each customer type.

4. Determine the operating income and operating income percentage of sale for each customer type.

5. Which customer is the most profitable based on the following profitability measures.

A) Gross Margin

B) Gross margin percentage of sales

C) Operating income

D) Operating income percentage of sales

Please show how all solutions were computed.