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 Shipping to Trenton Cost Tacoma Cost Per Unit Per Unit Chicago 4000 $75 $60 Dallas 3000 $100 $70 Atlanta 3700 $82 $90 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 Chicago 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 Shipping to Trenton Cost Tacoma Cost Per Unit Per Unit Chicago 4000 $75 $60 Dallas 3000 $100 $70 Atlanta 3700 .$82 $90 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 total transportation cost?(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 Shipping to Trenton Cost Tacoma Cost Per Unit Per Unit Chicago 4000 $75 $60 Dallas 3000 $100 $70 Atlanta 3700 $82 $90 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)
