1. 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.

SPREADSHEET FOR CALCULATIONS Intensive Distribution Selective Distribution d. Hydropam's marketing manager thinks that the type of channel relationship possible with selectie distribution would make at possible to get a lage share (40 percent of the pumps sold by its hot tub dealers. But be realizes that the chal percent might vary He think that the parent could be low A percentar as high as 45 percent. Ile wants to evaluate the effect that this might have an expected profits. Do a What If analysis, based une scelte distru t tive, lying Hechos cos pecul oldala unul sales between 35 percent and 45 percent and displaying Hydropropunit sales and profit, and then complete the missing mumbers in the table below. 18000.00 3420CO.CO 200000.00 120000.00 35.00 Percent of Dealer Unit Sales Expected Unit Sales Number of Retailers Retailers per Sales Rep Sales Reps Needed Salary per Sales Rep Personal Selling Expense Massing Expense Overhead Cost Cost to produce a Pump Total Pumps Sold by Dealers Hydrogenu's Percent of Dealers Unuts Total Expected Units Price to Retailers Hydropp Total Rereme Hydrapan Total Code Hidup Profit Expected Profit 13000 CO 7200000 SOOCO.CO 2000.00 3500 20000 4000 10400 7500 200000 0 0000 214000.00 11|| 14.00 193.210 24500 7000 121500000 1S1050000 195500.00 ||| SPREADSHEET EXCELLATIONS tnpscspatnre t arts to saf tharmai nelamarthy omnis w HTT al s elect that the capacity. He is the p r e ss relegats Porco Be was to eat tastat tag e de pested proate. Doa Watulys, based on the distan c e of antibm 15 45 p a daling sa cand in complete the wingers in the Deike Sales SPREADSHEET FOR CALCULATIONS Intensive Distribution Selective Distribution d. Hydropam's marketing manager thinks that the type of channel relationship possible with selectie distribution would make at possible to get a lage share (40 percent of the pumps sold by its hot tub dealers. But be realizes that the chal percent might vary He think that the parent could be low A percentar as high as 45 percent. Ile wants to evaluate the effect that this might have an expected profits. Do a What If analysis, based une scelte distru t tive, lying Hechos cos pecul oldala unul sales between 35 percent and 45 percent and displaying Hydropropunit sales and profit, and then complete the missing mumbers in the table below. 18000.00 3420CO.CO 200000.00 120000.00 35.00 Percent of Dealer Unit Sales Expected Unit Sales Number of Retailers Retailers per Sales Rep Sales Reps Needed Salary per Sales Rep Personal Selling Expense Massing Expense Overhead Cost Cost to produce a Pump Total Pumps Sold by Dealers Hydrogenu's Percent of Dealers Unuts Total Expected Units Price to Retailers Hydropp Total Rereme Hydrapan Total Code Hidup Profit Expected Profit 13000 CO 7200000 SOOCO.CO 2000.00 3500 20000 4000 10400 7500 200000 0 0000 214000.00 11|| 14.00 193.210 24500 7000 121500000 1S1050000 195500.00 ||| SPREADSHEET EXCELLATIONS tnpscspatnre t arts to saf tharmai nelamarthy omnis w HTT al s elect that the capacity. He is the p r e ss relegats Porco Be was to eat tastat tag e de pested proate. Doa Watulys, based on the distan c e of antibm 15 45 p a daling sa cand in complete the wingers in the Deike Sales