Market Segmentation Completing this activity will help you learn to Analyze market segments including product territory and salesperson segments Extract information from a data set using Excel formulas functions andor pivot tables Scenario Company A began business operations on April 1 of this year The company sells four models of tortoise shell design lamps the Donatello the Raphael the Michelangelo and the Leonardo The sales territories are divided into four regions throughout the country with four sales people in each territory as follows Territory Sales People Sales People Sales People Sales People North Adam Bill Carl Dave South Evan Fred Gary Hank East Ivan John Kent Lynn West Mark Neil Otto Pete There are four customers in each region as follows Region Customers Customers Customers Customers North Zander Co Young Co Xavier Co Wilson Co South Vaughn Co Umber Co Tanner Co Schell Co East Rogers Co Quinn Co Powell Co Olsen Co West Norton Co Miller Co Lawson Co Kirby Co