Here is the current situation: Territory 1 2 3 4 5 6 7 8 9 10 Population No. of Total Population 65 years Nursing & older Homes 5,446,964 2,106 2,892,892 1,343 44,093,580 21,771,868 68,099,436 8,341,166 5,661 76,677,862 8,363,438 5,076 45,222,380 2,732,645 2,182 15,702,727 1,367,003 1,160 59,814,662 5,575,266 3,092 SUM TOTAL s where each of the 7 current salespeople live: Territory 1 New England 2 Mid-Atlantic 3 Midwest 4 Southeast 5 Southwest 6 Central 7 West 331,382,515 34,719,373 | 20,620 Nellie Maddie Max Sonna Wess Mary Diego Last Year's Sales $12,203,504 123,409 Nellie $7,785,822 82,022 Maddie $42,060,682 581,589 Max $26,788,029 483,920 Sonna $9,915,388 458,376 Wess $5,469,962 742,629 Mary $17,704,750 548,400 Diego Rep lives in New York Square Sales Rep Name Miles $0 $0 $0 $121,928,137 3,020,345 Maryland Illinois North Carolina Texas Colorado California Your goal: You need to realign the sales territories into 10 territories-based geographically. You may need to refer to a U.S. map as you do this. You should ensure that each rep has their home state in their territory so that they don't need to move. 2) How will you realign the sales teams? Use the spreadsheet to calculate. 3) What justification did you use for the territory assignment? Did you use the square miles, number of nursing homes, population over 65, last year's sales? Why did you do this? List at least 3 objections you may get from your current sales reps about the realignment. How will you respond to their objection? 4) 5) Make a chart showing: Sales Rep Name States in old territory States in new territory Last year's sales in old territory Last year's sales in new territory