Question: Please solve show steps. solve using ampl or excel preferably ampl A sand and gravel distribution company is planning to enter Texas market and is

Please solve show steps.

solve using ampl or excel preferably ampl

Please solve show steps. solve using ampl or

A sand and gravel distribution company is planning to enter Texas market and is in the process of developing new facilities and distribution system for their product. The company's goal is to partially serve the demand of Austin, Dallas, and Houston. They are considering opening warehouses in the following 5 locations: Bryan, Conroe, Hempstead, Montgomery, Waco. The company's objective is to minimize its total annual cost. The relevant information is given in the following table: 9 shipping cost ($/ton) Austin Dallas Houston capacity (ton) rent ($) Bryan 16 27 15 6,000 50,000 Conroe 27 30 6 2,000 30,000 Hempstead 15 28 3,000 40,000 Montgomery 21 31 4,000 30,000 Waco 16 15 29 6,000 60,000 Demand (ton) 4,000 7,000 7,000 Formulate this problem as an integer program. Solve using AMPL. Report the optimal shipping quantities (in tons) in the following table: 10 Austin Dallas Houston Bryan Conroe Hempstead Montgomery Waco How many warehouses should the company open? What is the optimal cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A sand and gravel distribution company is planning to enter Texas market and is in the process of developing new facilities and distribution system for their product. The company's goal is to...

Please solve it urgently. A sand and gravel distribution company is planning to enter Texas market and is in the process of developing new facilities and distribution system for their product.They...

For the exclusive use of A. Young NA0232 Daktronics (A): The U.S. Digital Signage Industry in 2010 Joseph Kavanaugh, Sam Houston State University Joshua Warne and Carol J. Cumber, South Dakota State...

Case Studies: For each, you will submit your electronic document (.doc, .docx, or PDF) via Blackboard before class begins on the assigned date. Your case study will be not less than six pages in...

AutoSave OFF H 5 + 5 = wa Douglas Case rev 9_7_21(2) (1) Home Insert Draw Design Layout References Mailings Review View Tell me Share Q Comments X LO Calibri (Bo... V 11 21 AaBbcDdEe AaBbCcDdEe AaBb...

Select an organisation with which you are familiar and write a report on how you would transform a clearly defined segment of the organisation into a sustainable business segment. Do not select an...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Case Summary Read the Discussion Assignment 2-1 on p.34 of the text Technology Adoption by Small Manufacturers. Consider yourself as a health care leader in a small not-for-profit hospital. You have...

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

Display in product ID order the product ID and total amount ordered of that product by the customer who has bought the most of that product; use a derived table in a FROM clause to answer this query.

This is the first of three milestone assignments that will lead to completion of your course project. In this assignment, you will complete Critical Element III: GAAP vs. IFRS. Recall that, due to...

A static budget report may be appropriate in evaluating a manager's effectiveness in controlling coats when the betawior of the costs in response to changes in activity is foeed. should be used when...

The following information applies to Job 730 completed by Solomon Manufacturing Company during the month of October. The amount of labor cost for thejob was $89,850. Applied overhead amounted to...