Question

Heavenly Casket Company is trying to choose sites for the production of its "mail order" caskets. It is considering plants in Chicago, Dallas, and Atlanta. Finished caskets will then be sent to their two distribution sites in Trenton and Tacoma, which take orders over the internet. Heavenly expects demand of at least 4000 caskets per year in Trenton and at least 2500 in Tacoma. The table below gives annual plant capacity, and unit transportation costs between possible plant locations and the distribution sites: Site Capacity Shipping to Trenton Cost Per Unit Shipping to Tacoma Cost Per Unit Chicago 3500 $75 $50 Dallas 3200 $95 $70 Atlanta 3700 $82 $98 Formulate this transportation network problem as an integer linear programming model in order to minimize the total annual transportation cost. Implement the problem in excel and find the optimal solutions. What is the optimal shipping quantity from Atlanta to Trenton? (Please type ONLY NUMBERS with NO ROUNDING in the answer box)

          Heavenly Casket Company is trying to choose sites for the production of its "mail order"
caskets. It is considering plants in Chicago, Dallas, and Atlanta. Finished caskets will then be
sent to their two distribution sites in Trenton and Tacoma, which take orders over the
internet. Heavenly expects demand of at least 4000 caskets per year in Trenton and at least
2500 in Tacoma. The table below gives annual plant capacity, and unit transportation costs
between possible plant locations and the distribution sites:

Site Capacity Shipping to Trenton Cost Per Unit Shipping to Tacoma Cost Per Unit
Chicago 3500 $75 $50
Dallas 3200 $95 $70
Atlanta 3700 $82 $98

Formulate this transportation network problem as an integer linear programming model in
order to minimize the total annual transportation cost. Implement the problem in excel and
find the optimal solutions. What is the optimal shipping quantity from Atlanta to
Trenton? (Please type ONLY NUMBERS with NO ROUNDING in the answer box)

Heavenly Casket Company is trying to choose sites for the production of its "mail order"
caskets. It is considering plants in Chicago, Dallas, and Atlanta. Finished caskets will then be
sent to their two distribution sites in Trenton and Tacoma, which take orders over the
internet. Heavenly expects demand of at least 4000 caskets per year in Trenton and at least
2500 in Tacoma. The table below gives annual plant capacity, and unit transportation costs
between possible plant locations and the distribution sites:

Site Capacity Shipping to Trenton Cost Per Unit Shipping to Tacoma Cost Per Unit
Chicago 3500 7550
Dallas 3200 9570
Atlanta 3700 8298

Formulate this transportation network problem as an integer linear programming model in
order to minimize the total annual transportation cost. Implement the problem in excel and
find the optimal solutions. What is the optimal shipping quantity from Atlanta to
Trenton? (Please type ONLY NUMBERS with NO ROUNDING in the answer box)

Added by Josefa U.

Question

Please give Ace some feedback