Hydropump, Inc. produces and sells high-quality pumps to business customers. Its marketing research shows a growing market for a similar type of pump aimed at final consumers-for use with jacuzzi-style tubs in home remodeling jobs. Hydropump will have to develop new channels of distribution to reach this target market because most consumers rely on a retailer for advice about the combination of tub, pump, heater, and related plumbing fixtures they need. Hydropump's marketing manager. Robert Black, is trying to decide between intensive and selective distribution. With intensive distribution, he wouid try to sell through all the plumbing supply, bathroom fixture, and hot-tub retailers who will carry the pump. He estimates that about 5,600 suitable retailers would be willing to carry a new pump. With selective distribution, he would focus on about 280 of the best hot-tub dealers (two or three in the hundred largest metropolitan areas).

Intensive distribution would require Hydropump to do more mass selling-primarily advertising in home renovation magazines-to help stimulate consumer familiarity with the brand and convince retailers that Hydropump equipment will sell. The price to the retailer might have to be lower too (to permit a bigger markup) so they will be motivated to sell Hydropump rather than some other brand offering a smaller markup.

With intensive distribution, each Hydropump sales rep could probably handle about 300 retailers effectively. With selective distribution, each sales rep could handle only about 70 retailers because more merchandising help would be necessary. Managing the smaller sales force and fewer retailerswith the selective approach-would require less manager overhead cost.

Going to all suitable and available retailers would make the pump available through about 20 times as many retailers and have the potential of reaching more customers. However, many customers shop at more than one retailer before making a final choice-so selective distribution would reach almost as many potential customers. Further, if Hydropump is using selective distribution, it would get more in-store sales attention for its pump-and a larger share of pump purchases-at each retailer.

Black has decided to use a spreadsheet to analyze the benefits and costs of intensive versus selective distribution.

With intensive distribution, how large a share (percent) of the retailers' total unit sales would Hydropump have to capture to sell enough pumps to earn $200,000 profit?

Hydropump's marketing manager thinks that the type of channel relationship possible with selective distribution would make it possible to get a large share (40 percent) of the pumps sold by its hot-tub dealers. But he realizes that the actual percent might vary. He thinks that the percent could be as low as 35 percent, or go as high as 45 percent. He wants to evaluate the effect that this might have on expected profits. Do a What If analysis, based on the selective distribution alternative, varying Hydropump's percent of dealer unit sales between 35 percent and 45 percent and displaying Hydropump's unit sales and profit, and then complete the missing numbers in the table below.

Percent of Dealer Unit Sales	Expected Unit Sales	Expected Profit
35
37
	9880	193200
43
44
45