Please complete parts B and C

4. Sharon Stout is a sales representative for a pharmaceutical firm who has been assigned a territory in central Iowa. Throughout the year she has to make visits to doctors, pharmacists, and hospitals in her area. She is thinking about buying a home in Des Moines since she has many customers there. However, it is at the cor- ner of her territory and she wonders if she could cut down on the total number of miles she would have to drive each year if she lived in another location. The table below shows each of the cities in her area, their location, and her expected num- ber of trips per year there. CITY TRIPS PER YEAR e 62 12 Des Moines Newton Iowa City Cedar Rapids X-COORDINATE Y-COORDINATE 0 0 408 108 97 22 0 30 1 39 36 Ames 18 Waterloo 67 62 40 a. Formulate an NLP that would determine the home location that would mini- mize her total annual driving. b. Prepare a spreadsheet model and use Solver to find the optimal location. Turn in your spreadsheet model with your homework. X-coordinate: Y-coordinate: Total annual driving: C. How many driving miles does she save in the new location compared to Des Moines? 4. Sharon Stout is a sales representative for a pharmaceutical firm who has been assigned a territory in central Iowa. Throughout the year she has to make visits to doctors, pharmacists, and hospitals in her area. She is thinking about buying a home in Des Moines since she has many customers there. However, it is at the cor- ner of her territory and she wonders if she could cut down on the total number of miles she would have to drive each year if she lived in another location. The table below shows each of the cities in her area, their location, and her expected num- ber of trips per year there. CITY TRIPS PER YEAR e 62 12 Des Moines Newton Iowa City Cedar Rapids X-COORDINATE Y-COORDINATE 0 0 408 108 97 22 0 30 1 39 36 Ames 18 Waterloo 67 62 40 a. Formulate an NLP that would determine the home location that would mini- mize her total annual driving. b. Prepare a spreadsheet model and use Solver to find the optimal location. Turn in your spreadsheet model with your homework. X-coordinate: Y-coordinate: Total annual driving: C. How many driving miles does she save in the new location compared to Des Moines