Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show your steps in Solver, I can't get mine to show anything other than zero. Your company is building a new warehouse to serve

Please show your steps in Solver, I can't get mine to show anything other than zero.

Your company is building a new warehouse to serve six cities. It would like to minimize the total distance. The company wants to ensure that the warehouse is within 35 miles of each city. Here are the longitude and latitude coordinates for each city.

Longitude Latitude
City 1 90 80
City 2 75 63
City 3 67 89
City 4 45 102
City 5 103 120
City 6 57 89

1) Write out the mathematical model for this problem. Be sure to include the objective function, decision variables, and constraints

2) Setup the nonlinear programming model in Excel to determine where the warehouse should be placed and the total distance. Use Solver to find the optimal solution

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Via Wealthcare The 80 20 Way

Authors: Raj Baberwal

1st Edition

0557193001, 978-0557193004

More Books

Students also viewed these General Management questions

Question

The role that values play in our decision making.

Answered: 1 week ago