Question: I need the solution to this problem in AMPL programming. SC Consulting, a supply chain consulting firm, must decide on the location of its home
I need the solution to this problem in AMPL programming.
SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 16 states listed in Table 5-4. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,428, Tulsa is $131,230, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown in Table 5-4. Each consultant is expected to take at most 25 trips each year.
a. If there are no restrictions on the number of consultants at a site and the goal is to minimize costs, where should the home offices be located and how many consultants should be assigned to each office? What is the annual cost in terms of the facility and travel?
b. If at most 10 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of the network?
c. What do you think of a rule by which all consulting projects out of a given state are assigned to one home office? How much is this policy likely to add to cost compared to allowing multiple offices to handle a single state?

I need the solution to this problem in AMPL programming.
Number of Trips 40 35 100 25 40 25 TABLE 5-4 Travel Costs and Number of Trips for SC Consulting Travel Costs (5) State Los Angeles Tulsa Denver Seattle Washington 150 250 200 25 Oregon 150 250 200 75 California 75 200 150 125 Idaho 150 200 125 125 Nevada 100 200 125 150 Montana 175 175 125 125 Wyoming 150 175 100 150 Utah 150 150 100 200 Arizona 75 200 100 250 Colorado 150 125 25 250 New Mexico 125 125 75 300 North Dakota 300 200 150 200 South Dakota 300 175 125 200 Nebraska 250 100 125 250 Kansas 250 75 75 300 Oklahoma 250 25 125 300 50 30 50 65 40 30 20 30 40 55Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
