...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
...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 540 WK...
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
...Face Any Problem E- 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...
Words: 388 - Pages: 2
...known. The transshipment model is an extension of the transportation model in which intermediate transshipment points are added between the sources and destinations. An example of a transshipment point is a distribution center or warehouse located between plants and stores. In a transshipment problem, items may be 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
...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
...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
