Assignment #4 Case Problem: Stateline Shipping and Transport Company MAT540: Quantitative Methods Vargha Azad 09/08/13 In Excel‚ or other suitable program‚ develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. Solve the model you developed in #1 (above) and clearly describe the results. In Excel‚ or other suitable program. Develop a transshipment model in which each of the plants and disposal sites
Premium Microsoft Excel Waste Waste management
Assignment #4: Case Problem "Stateline Shipping and Transport Company" Read the ’Stateline Shipping and Transport Company" Case Problem on pages 273-274 of the text. Analyze this case‚ as follows: In Excel‚ or other suitable program‚ develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. Solve the model you developed in #1 (above) and clearly describe the results. In Excel‚ or other suitable program‚ Develop a transshipment model in which each of the
Premium Mathematics Interpretation Microsoft Excel
Assignment #4: Case Problem “Stateline Shipping and Transport Company” Courtney Boone June 10‚ 2012 MATH 540 Quantitative Methods Professor Gelonia Dent Rachel has estimated the cost of shipping a barrel of waste from each of the six plants to each of the three waste disposal sites as shown in the following table: Waste Disposal Site | | | | Plant | Whitewater | Los Canos | Duras | Kingsport | $12 | $15 | $17 | Danville | 14 | 9 | 10 | Macon | 13 | 20 | 11 | Selma | 17
Free Waste Waste management Recycling
1. Formulation of the Problem The Stateline Shipping and Transport Company wanted to transport industrial wastes from the 6 plants to the 3 waste disposable sites. The problem can be represented in as a Transportation table as shown below. Our problem is to find roots to disposable sites‚ such that the cost of transportation is minimized.. White water Los Canos Duras Availability (bbl) Kingsport $12.00 $15.00 $17.00 35 Danville $14.00 $9.00 $10.00 26 Macon $13.00 $20.00 $11.00 42 Selma
Premium Transport Waste management Cost
Introduction The Stateline Shipping and Transport Company is negotiating a shipping contract with Polychem. Polychem would like Stateline to pick up and transport their waste products from their six plants to three waste disposal sites. There is a possibility that using the plants and waste disposal sites as intermediate shipping points could lower the overall shipping costs. A Stateline manager is trying to determine the shipping routes that will minimize Stateline’s total cost and if it would
Free Waste Waste management Recycling
Stateline Shipping and Transport Company Stateline Shipping and Transport Company School of Business MAT 540 This paper was presented in submission for MAT 540 assignment four (Part 1 Only). Abstract This paper serves as a written response to the instructions and questions asked in assignment four. Assignment four instructed the writer to read the case problem Stateline Shipping and Transport Company from pages 273-274 in the text‚ Introduction to Management Science by Bernard W. Taylor. The
Premium Transport Optimization Costs
Assignment #4: Case Problem “Stateline Shipping and Transport Company” 1) This transportation model problem consists of 18 decision variables‚ representing the number of barrels of wastes product transported from each of the 6 plants to each of the 3 waste disposal sites: [pic]= Number of Barrels transported per week from plant ‘i’ to the j-th waste disposal site‚ where i = 1‚ 2‚ 3‚ 4‚ 5‚ 6 and j = A‚ B‚ C. The objective function is to minimize the total transportation cost for all shipments
Premium Waste Transport Waste management
Assignment #4: Case Problem “Stateline Shipping and Transport Company” 1. In Excel‚ or other suitable program‚ develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. White water Los Canos Duras Availability Kingsport $12.00 $15.00 $17.00 35 Danville $14.00 $9.00 $10.00 26 Macon $13.00 $20.00 $11.00 42 Selma $17.00 $16.00 $19.00 53 Columbus $7.00 $14.00 $12.00 29 Allentown $22.00 $16.00 $18.00 38 Capacity 65 80 105 223 The objective of the problem is to develop
Premium Prime number Waste Costs
Strayer university | Stateline shipping and Transportation Company | [Type the document subtitle] | | | 9/3/2012 | | 1. Objective function: Min Z= 12Xkw + 15Xkl + 17Xkd + 14Xdw + 9Xdl + 10Xdd + 13Xmw + 20Xml + 11Xmd + 17Xsw + 16 Xsl + 19Xsd + 7Xcw + 14Xcl + 12Xcd + 22Xaw + 16Xal + 18Xad Supply from 6 plants: 35‚26‚42‚53‚29‚38 Demand from 3 waste sites: 65‚80‚105 2. Using POM QM to solve the problem‚ the cost for shipping the waste directly from the 6 plants to the 3
Premium Transport Ship Cargo
transportation problem consists of 18 decision variables‚ representing the number of barrels of wastes transported from each of the 6 plants to each of the 3 waste disposal sites: = Number of Barrels transported per week from plant ‘i’ to the j-th waste disposal site‚ where i = 1‚ 2‚ 3‚ 4‚ 5‚ 6 and j = A‚ B‚ C. The objective function of the manager is to minimize the total transportation cost for all shipments. Thus the objective function is the sum of the individual shipping costs from each
Premium Transport Shipping Waste