The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, and C. The company has two customer types.
(Click the icon to view the sales and product cost information.)
The cost to serve all customers is $11,210 and is allocated to customer types based on the number of manager visits to customer locations for pre- and post-sales support.
Read the requirements.
Data table
X
Requirements
Product A
Product B
Product C
Product A Sales
$
Sales
Cost of sales
$ 4,600
Customer Type 1
Customer Type 2
4,000
$
5,800
4,600
$ 27,000
12,500
Total
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.
600
$
$ 4.600
Product B Sales
2,200
3.600
5,800
Product C Sales
17,000
10,000
27,000
Manager Visits
9
10
19
3. Determine the cost-to-serve percentage of sales for each customer type.
4. Determine the operating income and operating income percentage of sales for each customer type.
5. Which customer is the most profitable based the following profitability measures:
a. Gross margin
b. Gross margin percentage of sales
c. Operating income
d. Operating income percentage of sales
