Free Essay

Stateline Shipping Assignment

In:

Submitted By Nieceyb23
Words 1320
Pages 6
(1) Original problem
This is a Transportation problem for cost minimization. The problem is that the company has six collection centres from where company wants to collect waste and then transported to three disposable centres at a minimum cost. The different costs from collection centres to disposable sites are given in a table as shown in the following table.

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

Model in the mathematical form

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. The objective function Z and constraints can be expressed 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
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 original Problem

The above problem without considering the intermediates sites are solved using excel solver and the final solution are given as follows

White water Los Canos Duras
Kingsport 35
Danville 26
Macon 42
Selma 1 52
Columbus 29
Allentown 28 10
Dummy 27

Therefore, the optimal transportation procedure is to transport
(1) 35 bbl from Kingport, 1 bbl from Selma and 29 bbl from Columbus to the White water waste disposal plant
(2) 52 bbl from Selma and 28 bbl from Allentown to Los Canos waste disposal plant
(3) 26 bbl from Danville, 42 bbl from Macon and 10 bbl from Allentown to the Duras waste disposal plant

The minimum cost=35*12+26*10+42*11+1*17+52*16+29*7+28*16+10*18
=$2822.

(3) Modified Problem

Since the company having another option to drop a load at a plant or disposal sites and then picked up and carried on the final destination without extra cost, we can find certain roots in this model, it is cheaper to drop and pick up loads at intermediate points rather than ship them directly. So dropping the waste at certain intermediate position as described below will give certain cost advantage to the shipping company. So by considering all such possibilities some intermediate points are identified to drop the waste to minimize cost of transportation. All such roots with the lowest cost are given in the following table. Among the new roots, the roots with minimum cost are marked in green.

Sl. No. Plant From Intermediate Position Disposal centre Cost Minimum cost
1 Kingsport ------------- Duras $17 $15 Kingsport Danville Duras $15
2 Macon -------------- Los Canos $20 $19 Macon Selma Los Canos $19
3 Selma ------------- White water $17 $10 Selma Columbus White water $10
4 Selma ------------- Duras $19 $14 Selma Macon Duras $14
5 Allentown ------------ White water $22 $20 Allentown Kingsport White water $20
6 Allentown ------------ Duras $18 $17 Allentown Danville Duras $17

Therefore, the original transportation problem can be modified using the intermediate points as follows. The reduced costs from the original model is marked in brown colour.

White water Los Canos Duras Availability (bbl)
Kingsport $12.00 $15.00 $15.00 35
Danville $14.00 $9.00 $10.00 26
Macon $13.00 $19.00 $11.00 42
Selma $10.00 $16.00 $14.00 53
Columbus $7.00 $14.00 $12.00 29
Allentown $20.00 $16.00 $17.00 38
Capacity (barrels) 65 80 105

Then the objective function Z of the modified problem and constraints are written as
Minimize Z=12X11+15X12+15X13+14X21+9X22+10X23+13X31+19X32+11X33+10X41+16X42+14X43+7X51+14X52+12X53+20X61+16X62+17X63
Subject to
X11+X12+X13=35
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.

(4) The modified transportation problem can be solved using excel solver and the following solutions were obtained

The new solution is given below.

White water Los Canos Duras
Kingsport 16 19
Danville 26
Macon 42
Shelma 36 17
Columbus 29
Allentown 38
Dummy 27

The minimum cost=16*15+19*15+26*9+42*11+36*10+17*14+29*7+38*16
=$2630.

Therefore, the new optimal transportation procedure using the intermediate sites is to transport
(1) 36 bbl from Shelma and 29 bbl from Columbus to the White water waste disposal plant
(2) 16 bbl from Kingsport, 26 bbl from Danville and 38 bbl from Allentown to Los Canos waste disposal plant
(3) 19 bbl from Kingsport, 42 bbl from Macon, 17 bbl from Shelma and 10 bbl from Allentown to the Duras waste disposal plant.
To get this cost advantage company must use the following roots for transportation. Waste from Kingsport to Duras (19 bbl) must take to Danville first and then from take Danville to Duras. Waste from Shelma to White water (36 bbl) must be transported and dropped at Columbus first and from there it must be shipped to White water. Waste from Shelma to Duras ($17 bbl) must be transported and dropped at Macon first and from there it must be shipped to Duras.

(5) Conclusion

Using the original problem the minimum cost of the company was estimated as $2822. But, using certain intermediate points to drop the waste to get cost advantage the original problem was modified and again solve using solver. The result showed that the new model caused a considerable reduction in transportation costs. The optimum cost of the Stateline Shipping Company reduced to $2630. To get this cost advantage company must use the following roots for transportation. Waste from Kingsport to Duras must take to Macon first and then from take Macon to Duras. Waste from Macon Los Canos should be transported to Selma first and then from Shelma to Los Canos. Waste from Shelma to White water must be transported and dropped at Columbus first and from there it must be shipped to White water. Waste from Shelma to Duras must be transported and dropped at Macon first and from there it must be shipped to Duras. Waste from Allentown to White water must be transported and dropped at Kingsport first and from there it must be shipped to White water. Finally waste from Allentown to Duras must be transported and dropped at Danville first and from there it must be shipped to Duras.

Limitations
The main limitation is that, in the above calculations, we have considered the cost aspect only. Handling of very dangerous industrial wastes cannot be considered based on cost aspect alone. In our problem, it should be noted that this waste contains hazardous elements and hence transportation of waste to many intermediate positions will increase the risk of the company. Another important limitation of this study is we have not considered the time required to transport waste from one station to another. If the waste from the sites do not reach at the disposable sites at proper time, dispose of wastes may become difficult. If we use intermediate sites to drop waste for cost advantage this delay become more serious. Also note that transporting and dumping of waste from one plant to another plant which is not meant for waste disposable may become legal problems.

Similar Documents

Free Essay

Assignment #4: Case Problem “Stateline Shipping and Transport Company”

...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

Premium Essay

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 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

Free Essay

Assignment # 4

...• 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

Premium Essay

Assignment 4

...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

Premium Essay

Mat 540 Entire Course Latest Strayer

...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

Premium Essay

Case Problem: Stateline Shipping and Transport Company

...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

Free Essay

Stateline Transhipment Models

...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

Premium Essay

Mat 540 (Quantitative Methods) Week 1 - 11 Entire Course

...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

Premium Essay

Business

...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

Premium Essay

Mat 540

...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

Premium Essay

Stateline Shipping

...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