hhhhhhhh hhh

d. 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 SPREADSHEET FOR CALCULATIONS 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 Intensive Selective on the selective distribution alternative, varying Hydropump's percent of dealer unit sales between 35 percent Distribution Distribution and 45 percent and displaying Hydropump's unit sales and profit, and then complete the missing numbers in the Number of Retailers 560 280 able below. Retailers per Sales Rep 300 70 Percent of Expected Expected Sales Reps Needed 19 Dealer Unit Sales Unit Sales Profit Salary per Sales Rep 8000.00 8000 00 35 Personal Selling Expense 42000,00 2000.00 Mass-selling Expense 200000.00 0000.00 37 Overhead Cost 20000.00 $0000.00 9,880 193,200 Cost to Produce a Pump 35.00 35.00 Total Pumps Sold by Dealers 175000 26000 43 Hydropump's Percent of Dealers' Units 14.00 10.00 44 Total Expected Units 24500 10400 Price to Retailers 70.00 75.00 Hydropump Total Revenue 715000.00 80000.00 Hydropump Total Cost 1519500.00 66000.00 Hydropump Profit 195500.00 214000.00