Using relevant costs provided in the case, determine the profitability of each of Best Chips business segments. Based on your analysis, should Best Chips consider the changes desired by Value Savings Stores? Why or why not?

A) Complete accurately the above segment profitability report (19 shaded areas AND calculations for MM Labeling AND Drug and MM Stocking and Delivery Costs: 5 total)

B) Explain why or why not Best Chips should consider the changes desired by Value Savings Stores. Use the findings from the financial report above AND 1-2 sentences commenting on the changes requested by Value Savings Stores.

Fill in the shaded blanks for this Best Chips, INC., Segment Profitability Report

Retail Accounts:	Grocery	Drug	Mass Merchandise
Unit Sales	6,100,000	1,200,000	2,400,000
Trade Price	$1.90	$1.90	$1.60
Revenue	$11,590,000
COGS/unit	$1.17	$1.17	$1.17
Unit Sales/segment	6,100,000	1,200,000	2,400,000
Subtotal COGS	$7,137,000	$1,404,000
Labeling Cost	n/a	n/a
COGS/segment	$7,137,000
Net Margin	$4,453,000
Controllable Fixed Costs
Stocking Cost	$1,170,000
Delivery Cost	$1,404,000
Total Controllable Fixed Costs:	$2,574,000
Profit/segment	$1,879,000

*Labeling Cost: see 2^nd to last paragraph on p. 428 for explanation.

PLEASE SHOW YOUR CALCULATION.

Table 2 on p. 428

Cost Category/Segment	Grocery 450 loc, 2 del/wk	Drug 240 loc, 1 del/wk	Mass Merch loc, del/wk
Stocking Cost ($/Delivery)	$25	$20
Delivery Cost ($/Delivery)	$30	$30

**Stocking Cost and Delivery Cost for each segment is the product of:

Cost/delivery x deliveries/week x 52 weeks x number of retail locations served

Grocerys Stocking Cost example: $25 x 2 dels/wk x 52 wks x 450 locations = $1,170,000

Grocerys Delivery Cost example: $30 x 2 dels/wk x 52 wks x 450 locations = $1,404,000

PLEASE SHOW CALCULATIONS FOR BOTH THE DRUG AND MASS MERCHANDISE STOCKING AND DELIVERY COSTS

Book:

Supply Chain Logistics Management 5th Edition

by Donald Bowersox (Author), David Closs (Author), M. Bixby Cooper (Author)

Problem: case 9

Editonal Information:

Aaron Delaney, logistics manager at Best Potato Chips, Inc.., was faced with a difficult task. Joe Kik, the new vice president, had circulated a letter from Best Potato Chips only mass merchandise customer, Value Savings Stores, complaining of poor operating performance. Among the problems cited by Value Savings Stores were: (1) frequent stockouts on store shelves (2) poor customer service responsiveness and (3) high prices for Best Potato Chips products. The letter suggested that if Best Potato Chips were to remain a supplier to Value Savings Stores, it would need to eliminate stockouts by: (1) providing direct store delivery four times per week (instead of three) (2) installing an automated order inquiry system to increase customer service responsiveness ($600,000 investment) and (3) decreasing product prices paid by Value by 5 percent. While the previous vice president would most certainly have begun implementing the suggested changes, Joe Kik was different. He requested that Aaron prepare a detailed analysis of Best Potato Chips profitability by segment. He also asked that it be prepared on a spreadsheet to permit some basic analysis. This was something that Aaron had never previously attempted, and it was needed first thing in the morning.

Best Potato Chips, Inc., is the second largest potato chip producer in the mid-Michigan market. The company was founded in 1962 and following an unsuccessful attempt at national expansion has remained primarily a regional operation. The company currently manufactures and distributes several varieties of potato chips to three different types of retail accounts: grocery, drug, and mass merchandise. The largest percentage of business is concentrated in the grocery segment, with 450 retail customer locations accounting for 6,100,000 annual unit sales and more than 65 percent of annual revenue. The drug segment comprises 240 customer locations which account for 1,200,000 annual unit sales and about 13 percent of annual revenue. In the mass merchandise segment, Best Potato Chips has one customer (Value Savings) with 36 locations that account for 2,400,000 annual unit sales and almost 22 percent of annual revenue. All distribution is store-direct, with delivery drivers handling returns of outdated material and all shelf placement and merchandising.

Recently, Best Potato Chips has actively sought growth in the mass merchandise segment because of the perceived profit potential. However, while the company is acutely aware of overall business profitability, there has never been an analysis on a customer segment basis.

Performance Statistic

Aaron recently attended a seminar at a major midwestern university concerning activity-based costing. He was anxious to apply the techniques he had learned at the seminar to the current situation, but was unsure exactly how to proceed. He did not understand the relationship between activity-based costing and segment profitability analysis, but he knew the first step in either is to identify relevant costs. Aaron obtained a copy of Best Potato Chips most recent income statement(table1)

Table 1:

Income net sales: 17,710,000

cost and expenses: 11,359,000

cost of goods sold: 5,312,000

Marketing, Sales, Logistics and Other expenses: 16,771,000

Earnings before income taxes: 939,000

He also knew specific information concerning logistic costs by segment (table 2). All deliveries were store-direct with two deliveries per week to grocery stores, one delivery per week to drug stores and three deliveries per week to mass merchandiser stores. The cost of delivery to each store was dependent on the type of vehicle used and the amount of time spent at store locations. Standard route trucks were used for drug stores and grocery stores, while extended vehicles were used to accommodate the volume at mass merchandisers.

Table 2:

Cost Category/Segment	Grocery	Drug	Mass Merchandise
Stocking Cost ($/Delivery)	$25	$20	$50
Delivery Cost ($/Delivery)	$30	$30	$55

Trade prices for grocery and drug stores were $1.90 per unit and $1.60 for Value Savings. Aaron was also aware that Value Savings Stores required Best Potato Chips to cover the suggested retail price with a sticker bearing its (reduced) retail price. The machinery required to apply these labels had an annual lease cost of $60,000.00. Labor and materials for the labels cost an additional $.06 per unit.

Conclusion

As Aaron sat in his office compiling information to complete the segment profitability analysis, he received several unsolicited offers for assistance. Bill Smith, manager marketing, urged him not to bother with the analysis:

Value Savings Stores is clearly our single most important customer. Look at the sales per store. We should immediately implement the suggested changes.

Steve Brown, director of manufacturing, disagreed. He felt the additional manufacturing cost required to meet Value Savings Stores requirements was too high:

We should let Value Savings Stores know what we really think about their special requirements. Stickers, of all things! What business do they think we are in?

The sales force had a different opinion. Jake Williams felt the grocery segment was most important:

Just look at that volume! How could they be anything but our best customers?

The broad interest being generated by this assignment worried Aaron. Would he have to justify his recommendations to everyone in the company? Aaron quietly closed his office door.

Based on the available information and his own knowledge of ABC systems, Aaron needed to complete a segment profitability analysis before his meeting with Joe in the morning. With all these interruptions, it was going to be a long night.