Premium Essay

Transshipments and Transportation Models

In:

Submitted By stkelly000
Words 294
Pages 2
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.

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:

The objective function is to minimize the total transportation cost for all shipments. The objective function is the sum of the individual shipping costs from each plant to each waste disposal site: Minimize Z = 12N+ 15N+ 17N+ 14N+ 9N+ 10N+ 13N+ 20N +11N +17N +16N +19N +7N +14N +12N +22N +16N +18N
Z=12X11+15X12+17X13+14X21+9X22+10X23+13X31+20X32+11X33+17X41+16X42+19X43+7X51+14X52+12X53+22X61+16X62+18X63
The constraints are the number of barrels of wastes available per week at each plant and the number of barrels of wastes contained at each waste disposal site. Therefore there are 9 constraints- one for each plant supply and one for each waste disposal site’s demand.
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. 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.
The total shipping cost for the 6 plants to the 3 waste sites is $2630 as showed in the excel sheet below.

Similar Documents

Premium Essay

Mat 540 Week 10 Homework

...Question 1: “Transshipment Problems” Can we apply transshipment models to inventory applications? Why or why not? Is the transportation model an example of decision making under certainty or decision making under uncertainty? Why? Can we apply transshipment models to inventory applications? Why or why not? Yes, transshipment models can be applied to inventory applications. This will ensure lower costs through proper management and disbursement of the inventory while providing faster response times. The inventory levels can be managed by location in order to ensure minimal levels and the shipping will occur for less cost and faster service due to inventory placement within regions (Taylor III, 2011).  Is the transportation model an example of decision making under certainty or decision making under uncertainty? Why? The transportation model is an example of decision making under certainty. The data, in this case the route and items, has to be known in order for the decision making to be determined under certainty (Taylor III, 2011). Explain the assignment model and how it facilitates in solving transportation problems.  What benefits would be gained from using this model? 2ND RESPONSE Can we apply transshipment models to inventory applications? Why or why not? Yes, it does seem that transshipment models can be applied to inventory applications. Inventory applications deal with transporting goods to different destinations just like the transshipment models. By applying...

Words: 797 - Pages: 4

Free Essay

Backwaters

...Transportation Model 1 Transportation Problems • Transportation Problem – A distribution-type problem in which supplies of goods that are held at various locations are to be distributed to other receiving locations. – The solution of a transportation problem will indicate to a manager the quantities and costs of various routes and the resulting minimum cost. – Used to compare location alternatives in deciding where to locate factories and warehouses to achieve the minimum cost distribution configuration. – Some of the examples are: Shipment from factories to warehouses, Shipment between departments within a company, Shipment from warehouses to retailers 2 Formulating the Model • A transportation problem – Typically involves a set of sending locations, which are referred to as origins, and a set of receiving locations, which are referred to as destinations. – To develop a model of a transportation problem, it is necessary to have the following information: 1. Supply quantity (capacity) of each origin. 2. Demand quantity of each destination. 3. Unit transportation cost for each origin-destination route. 3 Transportation Model Example Harley’s Sand and Gravel Ltd. (Top soil Shipment) Problem: How many tons of Top soil to transport from each location (Farms) to each Project sites on a monthly basis in order to minimize the total cost of transportation ? Top soil can be supplied from 3 different locations Location Monthly Supply (in Tons) Farm A 100 Form B 200 Form C...

Words: 1248 - Pages: 5

Free Essay

Stateline Transhipment Models

...Can we apply transshipment models to inventory applications? Why or why not? Transshipment models can be applied to inventory applications because like transshipment models inventory applications deal transporting goods to different destinations. Items are transported from one destination to another just like inventory applications. Is the transportation model an example of decision making under certainty or decision making under uncertainty? Why? Transportation model is an example of decision making under certainty because the destinations of the goods are decided and are not unknown which makes the decision making a certainty because the destination is 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...

Words: 403 - Pages: 2

Free Essay

Stateline Shipping and Transport Company

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

Premium Essay

Budget Analysis

...Introduction to Transportation Problem Re-cap of linear programming, Classic transportation problem, LP formulation, Solution using MS Excel Text: BRS 5.1, 5.2, 5.3 Class 2: Transportation Problem (cont.) Basic feasible solution of TP, properties, Analysis of Excel output, Sensitivity analysis Text: BRS 5.1, 5.2, 5.3 Class 3: Transshipment problem Formulation of LP model, different variations (unbalanced case, combining with production scheduling, multi-modal and multi-SKU transportation), Conversion of transshipment model into classic transportation model. Text: BRS 5.4, 5.5 Class 4: Assignment problem Binary ILP formulation, solution by Hungarian method Text: BRS 5.6 Class 5: Network models Shortest path problem, Minimal spanning tree Text: BRS 5.8, 5.9 Class 6: Game theory Introduction to game theory: Types of game, Two person zero-sum game, concept of saddle point, dominance rule Text: WW 14.1, 14.2 Class 7: Game theory (contd.) Mixed startegy, Linear programming formulation Text: WW 14.2, 14.3 Class 8: Mid-term Test Class 9: Markov chain Introduction to stochastic processes, markov chains, transition probability matrix, steadystate probabilities. Text: Handouts and WW 17.1, 17.2, 17.3 Class 10: Decision theory Decision making under uncertainty, Decision criteria, Decision Tree Text: BRs 8.1, 8.2, 8.3, 8.4, 8.6 Class 11: Decision theory (contd.) Decision making under risk, EVPI, EVSI Text: 8.5, 8.8, 8.9 Class 12: Travelling Salesman Problem Optimization model formulation,...

Words: 354 - Pages: 2

Premium Essay

Doc 1

...[pic] |Quantitative Methods – MAT 540 | |Student Course Guide | |Prerequisite: MAT 300 | |INSTRUCTIONAL MATERIAL – Required | |( including all mandatory software) | |Taylor, B. M. (2010). Introduction to management science (10th ed.). Upper Saddle River, NJ: Pearson/Prentice Hall. | |Treeplan add-on for Excel. This software is available in the Open Lab at Strayer campuses, and can also be downloaded from the textbook's | |companion Website. http://wps.prenhall.com/bp_taylor_introms_10/112/28870/7390752.cw/-/7390754/index.html | | | |COURSE DESCRIPTION | |Applies quantitative methods to systems management...

Words: 2976 - Pages: 12

Premium Essay

Mat 540

...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) + 4C(19) + 5A(7) + 5B(14) + 5C(12) + 6A(22) + 6B(16) + 6C(18) III. The constraints in the model are the number...

Words: 1446 - Pages: 6

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

Mr Trials and Errors Lead to Pass

...www.VLCglobal.com/support VLC Course Descriptions Quantitative Analysis for Decision Making Quantitative Analysis for Decision Making An Immersive Virtual Reality Learning Experience 2011-2012 Course Description This course provides the student with the concepts, methods and tools for the application of logical and quantitative analysis to business decision making and problem solving. It familiarizes the student with a wide range of software and other classical and contemporary resources related to decision and problem analysis, including basics of logic and decision making, principles of optimization, probabilistic distributions, linear programming, simplex, queuing and transportation problems, break even analysis, inventory management, forecasting and simulation. The course highlights the benefits as well as the limits of quantitative analysis in a real-world context. This course may be adapted for the graduate and undergraduate levels. Materials Readings, assignments, problems and assessments are integrated into the courseware. Any additional materials will be assigned by the instructor at the start or during the course. Course Outline & Assignments Assignments will change from time to time as new resources become available, contemporary events have bearing on the topics, or the social, legal, or economic environments change. FUNDAMENTALS OF DECISION MAKING AND PROBLEM SOLVING (Module One, 4-6 hours) • • • • • • • • • • • • • • ...

Words: 1075 - Pages: 5

Premium Essay

Assignment 4

...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 the 3 disposal sites. Describe and implement the model. Did not submit or the objective function and/or constraints are specified with less than 70%...

Words: 589 - Pages: 3

Premium Essay

Ssssssssssssssss

...connectivity with the Mainland distribution network. ------------------------------------------------- Challenges The container terminals in Hong Kong have always been competing in productivity and efficiency, but indeed there are challenges faced by the Port. To maintain competitiveness, the container port needs to enhance its productivity and efficiency both on the land side and the quay side. On the land side, the container port has been built with an average of 14 hectares of land per 400 metres berth, which is about 45% below the international standard of 25 hectares for optimal performance. This has resulted in yard congestion especially during peak time, and in turn impacted the truck turnaround times. On the quay side, the transshipment throughput volume via barge operations has been increased nearly 30% in the past 10 years. The increase in barge volume has caused considerable barge waiting time and may disrupt connections with on-forwarding vessels. There is an urgent need for government support to increase the terminal back up land and also increase barge berths in the port area. Focusing on such challenges, the Association has submitted a White Paper to the Government proposing a land allocation policy for rationalization of terminal adjacent land and barge berths so as to facilitate improvement of productivity and efficiency on both land side and quay side The Association believes that the ability to provide efficient and reliable services will enable Hong Kong...

Words: 8232 - Pages: 33

Free Essay

Operations Research

...| Quantitative Methods-II, focuses on ‘Operations Research’ tools which helps in solving problems in different functional domain of business. It also helps to optimize business operations/processes. The Quantitative Method-II tools act as aids to decision makers to take best decision for effective & efficient use of resources which ultimately lead to profit maximization or to achieve multiple goals or objective. | Course must be aligned with a strategic objective of the program Prerequisites/Co-requisites | Quantitative Methods I | Learning Objectives | To learn basic optimization techniques and their managerial applications with a focus on methodologies such as Linear Programming, Transportation models, Assignment Models, Transhipment Models, Games Theory, Queuing Models, Goal Programming, Integer Programming, Non-linear Programming, Simulation and Decision Theory. | Learning objectives must be aligned with learning outcomes of the course Teaching Methods | Modeling, Case study, Software-based solutions | Refer academic policies and procedures handbook For Internal Use Only Session Plan* | SESSION-1: Overview on Operations Research modelling (OR modelling): meaning, definition, steps involved in OR modelling; Session-2: Overview on Linear Programming (LP): LP meaning, various applications,...

Words: 1342 - Pages: 6

Free Essay

Dealer Credit Center Operations Manager

...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: 345 - Pages: 2

Premium Essay

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

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

Words: 328 - Pages: 2

Premium Essay

Centralization

...Centralizing the entire process is always risky considering several features. The first very basic feature of the possible problem is caused because of a necessity for a just in time management style. If, infrastructural situations, unpredictable weather conditions, bad forecasting of the supplier etc. causes a problem with the delivery of units, unavailability of those units would create a sense of unreliability and lack of professionalism in the eyes of the customers, and ultimately lower the satisfaction of the customers. There might be several possible solutions for this problem: Firstly, either with already existing small delivery trucks, or with the purchase of additional transportation units, delivery service can become more risk averse, and the business model would be more stable. Another option we have thought of, we may require a more fundamental change of the plan the company wants to implement. In the case, the data which includes the location of the warehouses that are being planned to get closed is included. When clustered together, it is possible to see every closest 3 district has perfect locations in the middle, for storage facilities, where reaching to either one of these 3 locations would be quite easy. Company may prefer to denote the number of the warehouses from 1 to every district, to 1 to every three close locations. That way provides a risk aversion as well as a significant amount of profit as an outcome, although the how applicable this option would...

Words: 478 - Pages: 2