...Stateline Shipping And Transport Company 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 $17.00 $16.00 $19.00 53 Columbus $7.00 $14.00 $12.00 29 Allentown $22.00 $16.00 $18.00 38 Capacity (barrels) 65 80 105 Mathematical Formulation Let Xij i=1,2,3,4,5,6; j =1,2,3 denote the quantity of waste transported from i-th plant to j-th waste disposal centre. Then the objective function Z representing the cost and different constraints of the problem can be written as Minimize Z=12X11+15X12+17X13+14X21+9X22+10X23+13X31+20X32+11X33+17X41+16X42+19X43+7X51+14X52+12X53+22X61+16X62+18X63 Subject to X11+X12+X13 = 35 Is this essay helpful? Join OPPapers to read more and access more than 600,000 just like it! get better grades X21+X22+X23 = 26 X31+X32+X33 = 42 X41+X42+X43 = 53 X51+X52+X53 = 29 X61+X62+X63 = 38 X11+X21+X31+X41+X51+X61 65 X12+X22+X32+X42+X52+X62 80 X13+X23+X33+X43+X53+X63 105 Xij 0, i=1,2,3,4,5,6; j=1,2,3. 2. The transportation problem described above can be solved mathematically using a computer...
Words: 385 - Pages: 2
...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 assignment then directed the writer to Formulate and Solve and linear transportation programming model, this step was done in QM. The linear programming model is attached herein. Keywords: Linear Programming, Transportation, Shipping, Model Introduction This Case Problem, Stateline Shipping and Transport Company, is based on a girl named Rachel Sundusky who is a manager of the South-Atlantic office for Stateline Shipping and Transport (Taylor, 2010). Rachel is negotiating a contract with Polychem an industrial use chemical company (Taylor, 2010). Polychem has six sites that it would like for Stateline to pick up waste from (Taylor, 2010). Polychem would then like for Stateline to transport the waste for disposal to one of three sites (Taylor, 2010). Polychem has agreed to handle all of the waste at all sites therefore Stateline needs only transport the materials and incur costs for the same (Taylor, 2010). Rachel would like to see what the less costly shipping routes are (Taylor, 2010). Rachel will need all of the...
Words: 1105 - Pages: 5
...• 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: 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. 2. 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 can be used as intermediate points. 3. Solve the model you developed in #3 (above) and clearly describe the results. 4. Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph. There are two deliverables for this Case Problem, the Excel spreadsheets and an accompanying written description/explanation. Please submit both of them electronically via the dropbox. The assignment will be graded using the associated rubric. |Outcome Assessed: |Develop solutions for transshipment problems. | | |Communicate issues in Management Science | |Grading Rubric for Stateline Shipping & Transport Case Problem ...
Words: 586 - Pages: 3
...Week 10 Assignment Click the link above to submit your assignment 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 plants and disposal sites can be used as intermediate points. Solve the model you developed in #3 (above) and clearly describe the results. Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph. There are two deliverables for this Case Problem, the Excel spreadsheets and an accompanying written description/explanation. Please submit both of them electronically via the dropbox. The assignment will be graded using the associated rubric. Outcome Assessed: Develop solutions for transshipment problems. Communicate issues in Management Science Grading Rubric for Stateline Shipping & Transport Case Problem There are 12 points in each of the five criteria for a total of 60 points possible Criteria 0 Unacceptable (0 points) 1 Developing (6 points) 2 Competent (9 points) 3 Exemplary (12 points) 1. Develop...
Words: 589 - Pages: 3
...WK 2 Quiz 2 Chapter 11,12 MAT 540 WK 3 Assignment 1 – JET Copies Case Problem MAT 540 WK 3 Homework Chapter 14 MAT 540 WK 4 Assignment 2 – Internet Field Trip MAT 540 WK 4 Homework Chapter 15 MAT 540 WK 5 Midterm Exam MAT 540 WK 6 Homework Chapter 2 MAT 540 WK 6 Quiz 3 Chapter 2 MAT 540 WK 7 Assignment 3 Case Problem – Julia’s Food Booth MAT 540 WK 7 Homework Chapter 3 MAT 540 WK 8 Homework Chapter 4 MAT 540 WK 8 Quiz 4 Chapter 4 MAT 540 WK 9 Homework Chapter 5 MAT 540 WK 9 Quiz 5 Chapter 9 MAT 540 WK 10 Assignment 4 Case Problem – Stateline Shipping and Transport Company MAT 540 WK 10 Homework Chapter 6 MAT 540 WK 11 Final Exam Course Home Work aims to provide quality study notes and tutorials to the students of MAT 540 Entire Course Latest Strayer in order to ace their studies. MAT 540 ENTIRE COURSE LATEST STRAYER To purchase this visit following link: https://coursehomework.com/product/mat-540-entire-course-latest-strayer/ Contact us at: HELP@COURSEHOMEWORK.COM MAT 540 ENTIRE COURSE LATEST STRAYER MAT 540 WK 1 Homework Chapter 1,11 MAT 540 WK 1 Quiz 1 Chapter 1,11 MAT 540 WK 2 Homework Chapter 12 MAT 540 WK 2 Quiz 2 Chapter 11,12 MAT 540 WK 3 Assignment 1 – JET Copies Case Problem MAT 540 WK 3 Homework Chapter 14 MAT 540 WK 4 Assignment 2 – Internet Field Trip MAT 540 WK 4 Homework Chapter 15 MAT 540 WK 5 Midterm Exam MAT 540 WK 6 Homework Chapter 2 MAT 540 WK 6 Quiz 3 Chapter 2 MAT 540 WK 7 Assignment 3 Case Problem – Julia’s Food Booth MAT...
Words: 667 - Pages: 3
...Case Problem: Stateline Shipping and Transport Company 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 can be used as intermediate points. 6 Plants labeled 1 through 6, 3 waste facilities labeled A through C Objective function: Minimize Z = 1A(12) + 1B(15) + 1C(17) + 2A(14) + 2B(9) + 2C(10) + 3A(13) + 3B(20) + 3C(11) + 4A(17) + 4B(16) + 4C(19) + 5A(7) + 5B(14) + 5C(12) + 6A(22) + 6B(16) + 6C(18); Subject to: 1A + 1B + 1C = 35 2A + 2B + 2C = 26 3A + 3B + 3C = 42 4A + 4B + 4C = 53 5A + 5B + 5C = 29 6A + 6B + 6C = 38 1A + 2A + 3A + 4A + 5A + 6A ≤ 65 1B + 2B + 3B + 4B + 5B + 6B ≤ 80 1C + 2C + 3C + 4C + 5C + 6C ≤ 105 All Combinations ≥ 0 Solver add-on solution in MS Excel yielded the following results: 35 bbl of wastes shipped from Kingsport to Whitewater, 26 bbl of waste shipped from Danville to Duras, 42 bbl of wastes shipped from Macon to Duras, 1 bbl of wastes shipped from Selma to Whitewater, 52 bbl of wastes shipped from Selma to Los Canos, 29 bbl of wastes shipped from...
Words: 1072 - Pages: 5
...transported from sources through trans-shipment points on to destinations, from one source to another, from one transshipment point to another, from one destination to another, or directly from sources to destinations, or some combination of these alternatives. Therefore we can apply the transshipment models to inventory applications because deals with a source and destinations and they are similar. The transportation model is an example of decision making under certainty because the sources and destination are known factors before making the decision. Author: Anonymous Date: Thursday, April 28, 2011 4:35:45 PM EDT Subject: Week 10 Discussion 2 Explain the assignment model and how it facilitates in solving transportation problems. What benefits would be gained from using this model? Explain the assignment model and how it facilitates in solving transportation problems. The...
Words: 403 - Pages: 2
...Mail Us At JohnMate1122@gmail.com WEEK 1 Quiz 1 Set 1(20 Questions and Answers) Quiz 1 Set 2 (20 Questions and Answers) Quiz 1 Set 3 (20 Questions and Answers) WEEK 2 Discussion Question 1: Decision Tree Discussion Question 2: The Science of Probability Quiz 2 Set 1 (20 Questions and Answers) Quiz 2 Set 2 (20 Questions and Answers) WEEK 3 Assignment 1, Jet Copier Case Problem Discussion Question 1: Pseudorandom Discussion Question 2: Statistical Analysis WEEK 4 Assignment 2, Internet Field Trip Presentation Discussion Question 1: Forecasting Discussion Question 2: Forecasting Models WEEK 5 Midterm Exam 1 (40 Questions and Answers) Midterm Exam 2 (40 Questions and Answers) Midterm Exam 3 (40 Questions and Answers) Midterm Exam 4 (40 Questions and Answers) WEEK 6 Discussion Question 1: The Linear programming Model Discussion Question 2: The LP Model Discussion Question 3: Graphical Method Discussion Question 4: Minimization model Quiz 3 Set 1 (20 Questions and Answers) Quiz 3 Set 2 (20 Questions and Answers) Quiz 3 Set 3 (20 Questions and Answers) WEEK 7 Assignment 3, Case Problem, Julia's Food Booth Discussion Question 1: Shadow Price Discussion Question 2: Sensitivity Analysis Discussion Question 3: LP model and optimal solution. WEEK 8 Discussion Question 1: Objective Function Discussion Question 2: Applications of Linear Programming Quiz 4 Set 1 (20 Questions and Answers) Quiz 4 Set 2 (20 Questions and Answers) ...
Words: 388 - Pages: 2
...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 a shipping schedule that minimizes the total cost of transportation. Suppose Xij denotes the number of barrels of wastes to be transported from the “i” plant to “j” site. Then the total cost of transportation is: Z = 12 X11 + 15 X12 + 17 X13 + 14 X21 + 9 X22 + 10 X23 + 13 X31 + 20 X32 + 11 X33 + 17 X41+ 16 X42 + 19 X43 + 7 X51 + 14 X52+ 12 X53 + 22 X61 + 16 X62 + 18 X63. Thus the objective function of the problem is to minimize Z = 12 X11 + 15 X12 + 17 X13 + 14 X21 + 9 X22 + 10 X23 + 13 X31 + 20 X32 + 11 X33 + 17 X41+ 16 X42 + 19 X43 + 7 X51 + 14 X52+ 12 X53 + 22 X61 + 16 X62 + 18 X63. Constraints Availability in plants: X11 + X12 + X13 = 35 X21 + X22 + X23 = 26 X31 + X32 + X33 = 42 X41 + X42 + X43 = 53 X51 + X52 + X53 = 29 X61 + X62 + X63 = 38 Capacity of the sites: X11 + X21+ X31+X41 + X51 + X61 ≤ 65 X12 + X22+ X32+X42 + X52 + X62 ≤ 80 X13 + X23+ X33+X43 + X53 + X63 ≤ 105 Non- Negativity restrictions ...
Words: 382 - Pages: 2
...Stateline Shipping and Transport Company Assignment Name: Stephanie Airhart In Excel, or other suitable program, Develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. The Stateline Shipping and Transport Company wanted to transport chemical wastes from the six plants to the three waste disposal sites. The six pants and their capacity for wastes generated are shown below. Also shown are the three waste disposal sites and their demand requirements. Plants | Supply (barrels)) | | | 1. Kingsport | 35 | 2. Danville | 26 | 3. Macon | 42 | 4. Selma | 53 | 5. Columbus | 29 | 6. Allentown | 38 | Waste Disposal Sites | Demand (barrels) | A. Whitewater | 65 | B. Los Canos | 80 | C. Duras | 105 | Shown below are the shipping costs ($/per barrel) from each waste disposal site to each plants. Plants | Waste Disposal Sites | | A. Whitewater | B. Los Canos | C. Duras | 1. Kingsport | 12 | 15 | 17 | 2. Danville | 14 | 9 | 10 | 3. Macon | 13 | 20 | 11 | 4. Selma | 17 | 16 | 19 | 5. Columbus | 7 | 14 | 12 | 6. Allentown | 22 | 16 | 18 | Mathematical Formulation I. The six plants were represented by 1 through 6, while the three waste facilities were represented A through C. II. The objective function of the manager is to minimize the total transportation cost for all shipments. Minimize Z = 1A(12) + 1B(15) + 1C(17) + 2A(14) + 2B(9) + 2C(10) + 3A(13) + 3B(20) + 3C(11) + 4A(17) + 4B(16)...
Words: 1446 - Pages: 6
...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 a shipping schedule that minimizes the total cost of transportation. Suppose Xij denotes the number of barrels of wastes to be transported from the “i” plant to “j” site. Then the total cost of transportation is: Z = 12 X11 + 15 X12 + 17 X13 + 14 X21 + 9 X22 + 10 X23 + 13 X31 + 20 X32 + 11 X33 + 17 X41+ 16 X42 + 19 X43 + 7 X51 + 14 X52+ 12 X53 + 22 X61 + 16 X62 + 18 X63. Thus the objective function of the problem is to minimize Z = 12 X11 + 15 X12 + 17 X13 + 14 X21 + 9 X22 + 10 X23 + 13 X31 + 20 X32 + 11 X33 + 17 X41+ 16 X42 + 19 X43 + 7 X51 + 14 X52+ 12 X53 + 22 X61 + 16 X62 + 18 X63. Constraints Availability in plants: X11 + X12 + X13 = 35 X21 + X22 + X23 = 26 X31 + X32 + X33 = 42 X41 + X42 + X43 = 53 X51 + X52 + X53 = 29 X61 + X62 + X63 = 38 Capacity of the sites: X11 + X21+ X31+X41 + X51 + X61 ≤ 65 X12 + X22+ X32+X42 + X52 + X62 ≤ 80 X13 + X23+ X33+X43 + X53 + X63 ≤ 105 Non- Negativity restrictions Xij ≥ 0 , i = 1,2,3,4,5,6 ; j = 1,2,3...
Words: 2300 - Pages: 10