Fill in the boxes with ______ blanks for this BCPI Segment Profitability Report

Retail Accounts:	Grocery	Drug	Mass Merchandise (trade price reflects proposed 5% decrease)
Unit Sales	6,100,000	1,200,000	2,400,000
Trade Price	$1.90	$1.90	$1.52
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	______	______

Trade prices for grocery and drug stores were $1.90/unit and $1.60/unit for value savings. The machinery required to apply new labels had an annual lease of $60k/year and labels cost an additional .06 unit

BPC is the second-largest potato chip producer in the mid-Indiana 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, BPC has one customer (Vast 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, BPC 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.

BPC most recent income statement

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