Question

Costs of Different Customer Classes

Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $49 per case (a case contains 24 cans of nuts). Kaune sold 155,000 cases last year to the following three classes of customer:

Customer	Price per Case				Cases Sold
Supermarkets		$66				80,000
Small grocers		96				45,000
Convenience stores		88				30,000

The supermarkets require special labeling on each can costing $0.03 per can. They order through electronic data interchange (EDI), which costs Kaune about $55,000 annually in operating expenses and depreciation. Kaune delivers the nuts to the stores and stocks them on the shelves. This distribution costs $44,000 per year.

The small grocers order in smaller lots that require special picking and packing in the factory; the special handling adds $20 to the cost of each case sold. Sales commissions to the independent jobbers who sell Kaune products to the grocers average 7 percent of sales. Bad debts expense amounts to 8 percent of sales.

Convenience stores also require special handling that costs $28 per case. In addition, Kaune is required to co-pay advertising costs with the convenience stores at a cost of $18,000 per year. Frequent stops are made to each convenience store by Kaune delivery trucks at a cost of $24,000 per year.

Required:

1. Calculate the total cost per case for each of the three customer classes. Round intermediate calculations and final answers to four decimal places. Use the rounded values for subsequent requirements.

	Total Cost Per Case
Supermarkets	$
Small grocers	$
Convenience stores	$

2. Using the costs from Requirement 1, calculate the profit per case per customer class. Round intermediate computations to four decimal places and final answers to two decimal places.

	Profit Percentage Per Case
Supermarkets		%
Small grocers		%
Convenience stores		%

Does the cost analysis support the charging of different prices?

3. What if Kaune charged the average price per case to all customer classes? How would that affect the profit percentages?

Answer 1

1)

Customer	Price per	Cases	Sales
	Case	Sold	Amount
Supermarkets	$                 66.00	80,000.00	$   5,280,000.00
Manufacturing Cost	$                 49.00	80,000.00	$   3920,000.00
Special Labeling
0.03*24	$                   0.72	80,000.00	$        57,600.00
EDI			$        55,000.00
Distribution Cost			$        44,000.00
		Total Cost	$   4076,600.00
		Case Sold	80,000.00
		Cost per unit	$               50.9575

Customer	Price per	Cases	Sales
	Case	Sold	Amount
Small grocers	$                 96.00	45,000.00	$   4,320,000.00
Manufacturing Cost	$                 49.00	45,000.00	$   2,444,000.00
Handling Cost	$                 20.00	45,000.00	$      900,000.00
Sales Commision	7% of Sales		$      302,400.00
Bad debts	8% of Sales		$      345,600.00
		Total Cost	$   3992,000.00
		Case Sold	45,000.00
		Cost per unit	$               88.7111

Customer	Price per	Cases	Sales
	Case	Sold	Amount
Convenience stores	$                 88.00	30,000.00	$   2,640,000.00
Manufacturing Cost	$                 49.00	30,000.00	$   1,470,000.00
Handling Cost	$                 28.00	30,000.00	$      840,000.00
Advertising			$        18,000.00
Truck Cost			$        24,000.00
		Total Cost	$   2,352,000.00
		Case Sold	30,000.00
		Cost per unit	$               78.40

2)

Customer	Sale Price per	Cost per	Profit Per	Profit Per
	Case	Case	Case	Unit % on sales
Supermarkets	$   66.00	50.9575	$   15.04	22.79%
Small grocers	$   96.00	88.7111	$   7.29	7.59%
Convenience stores	$   88	78.4000	$ 9.6	10.91%

Customer	Price per	Cases	Sales
	Case	Sold	Amount
Supermarkets	$                 66.00	80,000.00	$   5,280,000.00
Small grocers	$                 96.00	45,000.00	$   4,320,000.00
Convenience stores	$                 88.00	30,000.00	$   2,640,000.00
		155,000.00	$ 12,240,000.00

3)

Average Sale Price=Total Sales/Total Units sold=$12,240,000/155,000=$78.9674