Provide a textbox with the NLP formulation. Place your optimal solution and optimal value in a separate textbox. Show work in EXCEL for REFERENCE

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 corner 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 number of trips per year there. a. Formulate an NLP that would determine the home location that would minimize 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