...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
...Stateline Shipping and Transport Company The transportation model will be set up by assigning a variable to each site. The plants Danville, Selma, and Columbus are 1, 2 and 3 respectively. This makes the waste disposal sites at White Water, Los Canos, Duras variables A, B and C, respectively. Decision variables: 1. Ship from 1: x1A, x1B, x1C 2. Ship from 2; x2A, x2B, x2C, 3. Ship from 3: x3A, x3B, x3C, The objective function is: Min. cost Z= 14x1A+9x1B+10x1C+17x2A+16x2B+19x2C+7x3A+14x3B+12x3C There will be one constraint for each location regardless of how many variables. Plant constraints: Output from plant 1: x1A + x1B + x1C =26 Output from plant 2: x2A + x2B + x2C = 53 Output from plant 3: x3A + x3B + x3C = 29 Waste disposal site constraints: Intake at site A: x1A + x2A + x3A ≤65 Intake at site B: x1B + x2B + x3B ≤80 Intake at site C: x1C + x2C + x3C ≤105 Once the data solver is set up the model comes up with this solution: Ship all Danville and Selma waste to Los Canos and all Columbus Waste to White Water to get a shipping cost of $1285.00 3. The transshipment model will follow the same logic as the transportation when setting up the variables. There will be a variable for each shipment from plant to plant, plant to waste disposal site and waste disposal site to waste disposal site. I started out Decision variables:...
Words: 587 - 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
...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 In the “Stateline Shipping and Transport Company” case there is the manager Rachel Sundusky of the South –Atlantic office of the Stateline Shipping and Transport Company. She is trying to negotiate a new shipping contract with Polychem where Stateline picks up and transport waste product form its six plants to three waste disposal sites. In this problem we are trying to determine the shipping routes the will minimize Stateline total cost. In the first part I set up the problem in excel showing the shipping to the waste directly from the six plants to the three waste disposal site. In the result I had a Z value which is the minimum cost of $3090.00 that Polychem will pay Stateline to transport their products. It also shows that Danville and Columbus is not safe to ship from because they cannot provide the supply that is needed. In the second part I develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points. In the results it shows that I had a Z value which is the minimum cost of 2884.00 that Polychem will pay Stateline to transport their products. Also shows that Danville is not worth using to ship from because they cannot provide the supply that is needed. The overall results show that it is cheaper for Stateline to use the routes where the plants and disposal sites can be used as intermediate points. In both models it shows that Danville is not a good shipping site. Over all in...
Words: 292 - Pages: 2
...Stateline Shipping and Transport Company Carla Coleman Strayer University MAT 540: Quantitative Method Dr. Luke Howard March 20, 2014 2014 Case Study: Stateline Shipping and Transport Company In this case study, we are introduced to Rachel Sundusky, the manager of the South-Atlantic office of the Stateline Shipping and Transport Company. The information we are given is that Rachel is in the process of negotiating a new contract to haul hazardous chemical waste from six (6) locations to three (3) waste disposal sites for Polychem, a manufacturer or chemicals for industry use. Rachel has estimated both the cost to transport one barrel from each location to each disposal site, as well as between each location. In estimating these costs, Rachel took into account that some towns and municipalities where the six plants are located restrict the transportation of hazardous material within municipal limits, so costs in some cases had to include traversing circutous routes. Rachel is given the number of barrels of waste each of the six plant locations will need picked up and how many barrels each of the waste disposal sights can accept. Given this information, and the esimated shipping costs she has developed, Rachel would like to determine which shipping routes will minimize Stateline’s total cost. She would like to consider the cost to move the waste directly from each plant location to a...
Words: 525 - Pages: 3
...Stateline Shipping and Transport Company Strayer University MAT540 – Quantitative Methods September 1, 2011 Stateline Shipping and Transport Company 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 ($/bbl) from each waste disposal site to each plants. |Plants |Waste Disposal Sites | | |A. Whitewater...
Words: 309 - Pages: 2
...• 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
...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 a transportation model for shipping from the 6 plants directly to...
Words: 589 - Pages: 3
...Porsha is the manager of the South-Atlantic office of the Stateline Shipping and Transport Company is negotiating a shipping contract with Polychem. This company would like Stateline to pick up and transport their waste products from their six plants to three waste disposal sites. In efforts to minimize the potential hazardous barrels if leaks occur, she is seeking a possibility that using the plants and waste disposal sites as intermediate shipping points could lower the overall shipping costs too. Rachel is trying to determine the shipping routes that will minimize Stateline’s total cost and if it would be cheaper to ship directly from the plants to the waste sites or use intermediate shipping points (Taylor, 2011, p. 273-274). The estimated shipping costs ($/barrel) from the six plants to the three waste disposal sites are shown in Table 1. Plant A. Whitewater B. Los Canos C. Duras (Cost waste disposal site) The waste generated by the plants represents the supply for the transportation model and is shown in Table 2. Table 2 Plant Waste per Week (barrels) Waste Disposal Site Weekly Accommodation (barrels) Capacity (barrels) | 65 | 80 | 105 | each disposal sites The three waste disposal sites at Whitewater, Los Canos and Duras can accommodate a maximum of 65. 68 and 105 barrels per week, respectively. Let ij = quantity of waste transported from the plant to the waste center, The constraints in the model are the number of barrels of wastes available each...
Words: 349 - Pages: 2
...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 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...
Words: 667 - Pages: 3
...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
...1. Develop a transportation model for shipping from the 6 plants directly to the 3 disposal sites. Describe and implement the model. Please see tab one (Plant to Waste Shipment) of the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. The cost is $2,822 to ship. 2. Solve the model given in 1 and describe the results. The results of the model are as follows: 35 barrels per week from Kingsport Plant to Whitewater Waste Plant 26 barrels per week from Danville Plant to Duras Waste Plant 42 barrels per week from Macon Plant to Duras Waste Plant 1 barrel per week from Selma Plant to Whitewater Waste Plant 52 barrels per week from Selma Plant to Los Canos Waste Plant 29 barrels per week from Columbus Plant to Whitewater Waste Plant 28 barrels per week from Allentown Plant to Los Canos Waste Plant 10 barrels per week from Allentown Plant to Duras Waste Plant 3. Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points. Please see tab two (Intermediate Shipping) of the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. 4. Solve the model given in 3 and describe the results. The results of the model are...
Words: 345 - Pages: 2
...1. Develop a transportation model for shipping from the 6 plants directly to the 3 disposal sites. Describe and implement the model. Please see tab one (Plant to Waste Shipment) of the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. The cost is $2,822 to ship. 2. Solve the model given in 1 and describe the results. The results of the model are as follows: 35 barrels per week from Kingsport Plant to Whitewater Waste Plant 26 barrels per week from Danville Plant to Duras Waste Plant 42 barrels per week from Macon Plant to Duras Waste Plant 1 barrel per week from Selma Plant to Whitewater Waste Plant 52 barrels per week from Selma Plant to Los Canos Waste Plant 29 barrels per week from Columbus Plant to Whitewater Waste Plant 28 barrels per week from Allentown Plant to Los Canos Waste Plant 10 barrels per week from Allentown Plant to Duras Waste Plant 3. Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points. Please see tab two (Intermediate Shipping) of the attached spreadsheet after the data was analyzed and dropped into the Excel Spreadsheet and the Data Solver was utilized to obtain the stated highlighted results. 4. Solve the model given in 3 and describe the results. The results of the model are shown...
Words: 328 - Pages: 2
...Common Law, and Statutes. In my current profession at Southwest Gas I see laws affect each department in different ways. Southwest Gas implemented an entire legal department which consists of Lawyers, Paralegals and a Risk Management Team. In my limited experience with the company I have yet to see all aspects of the company that are affected by the functions of law. The Lawyers do most of the behind the scenes things that we as employees don’t see much of. The Paralegals draft legal letters that we as employees may need for miscellaneous reasons. The Risk Management Team is the front line of our Legal team out in the field. The Risk Management Team responds to employee vehicle accidents to document any particulars that may be need in court, while on scene they decide on employee drug tests and do most of the communication with authorities on scene. When Southwest Gas Construction Crews are involved in incidents that affect the gas to large areas of town including business, the Risk Management team surveys and assess the amount of damage and loss of revenue to assist in rapid payoffs to avoid legal action against the company. Southwest Gas is also involved in the transport of Natural Gas across Stateline....
Words: 472 - Pages: 2
