+ 3. Given the following data, find out the final sales force rank. Note: Show all...

Transcribed Image Text:

+ 3. Given the following data, find out the final sales force rank. Note: Show all your work. (30 points) Number of Accounts rank weight = 30%; Number of new accounts rank weight = 40%; Number of years rank weight = 20%; Weighted sales Trend rank weight = 10%; Sales reps can be ranked using median as follows: a) A Greater than (1.5 x median) b) B = Greater than median and less than or equal to (1.5 x median) c) C = Greater than (0.5 x median) and less than or equal to median Between minimum value or zero and (0.5 x median) d) D Weighted Sales Trend Cutoffs: A cutoff = 50% B cutoff = 30% IDIS 651: Distribution Customer Experience C cutoff = -7% D cutoff = -5% Sales Year 1 person (2021) ID Sales $ Year 2 (2022) Sales $ Year 3 Number of (2023) Sales $ Accounts Number of New Accounts Number of Years Efficiency Rank DP01 $936,536 $951,250 $1,195,147 217 66 13 A DP02 $224,964 $173,269 $489,458 784 103 4 C DP03 $909,292 $841,085 $1,018,978 276 54 2 D DP04 DP05 $547,156 $791,843 $737,688 $656,093 44 10 8 B $323,569 $677,264 658 7 10 C DP06 $414,420 $930,840 $689,850 506 54 11 B DP07 $823,558 $663,470 $419,828 464 7 1 D DP08 $962,469 $955,344 $508,784 450 25 2 A DP09 $331,541 $344,131 $345,079 584 91 20 C DP10 $477,144 $425,477 $592,279 480 6 5 A Rank Category AA Rainmakers AB Rainmakers AC Hunters AD Hunters BA Rainmakers BB Rainmakers BC Hunters BD Hunters CA Farmers CB Farmers CC Defenders CD Defenders DA Farmers DB Farmers DC Defenders DD Defenders + 3. Given the following data, find out the final sales force rank. Note: Show all your work. (30 points) Number of Accounts rank weight = 30%; Number of new accounts rank weight = 40%; Number of years rank weight = 20%; Weighted sales Trend rank weight = 10%; Sales reps can be ranked using median as follows: a) A Greater than (1.5 x median) b) B = Greater than median and less than or equal to (1.5 x median) c) C = Greater than (0.5 x median) and less than or equal to median Between minimum value or zero and (0.5 x median) d) D Weighted Sales Trend Cutoffs: A cutoff = 50% B cutoff = 30% IDIS 651: Distribution Customer Experience C cutoff = -7% D cutoff = -5% Sales Year 1 person (2021) ID Sales $ Year 2 (2022) Sales $ Year 3 Number of (2023) Sales $ Accounts Number of New Accounts Number of Years Efficiency Rank DP01 $936,536 $951,250 $1,195,147 217 66 13 A DP02 $224,964 $173,269 $489,458 784 103 4 C DP03 $909,292 $841,085 $1,018,978 276 54 2 D DP04 DP05 $547,156 $791,843 $737,688 $656,093 44 10 8 B $323,569 $677,264 658 7 10 C DP06 $414,420 $930,840 $689,850 506 54 11 B DP07 $823,558 $663,470 $419,828 464 7 1 D DP08 $962,469 $955,344 $508,784 450 25 2 A DP09 $331,541 $344,131 $345,079 584 91 20 C DP10 $477,144 $425,477 $592,279 480 6 5 A Rank Category AA Rainmakers AB Rainmakers AC Hunters AD Hunters BA Rainmakers BB Rainmakers BC Hunters BD Hunters CA Farmers CB Farmers CC Defenders CD Defenders DA Farmers DB Farmers DC Defenders DD Defenders