This website uses cookies to ensure you have the best experience. Learn more

Stateline Shipping Essay

2314 words - 10 pages

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 ...view middle of the document...

00 0.00
$C$14 Danville Los Canos 0.00 0.00
$D$14 Danville Duras 26.00 26.00
$B$15 Macon White water 0.00 0.00
$C$15 Macon Los Canos 0.00 0.00
$D$15 Macon Duras 42.00 42.00
$B$16 Selma White water 1.00 1.00
$C$16 Selma Los Canos 52.00 52.00
$D$16 Selma Duras 0.00 0.00
$B$17 Columbus White water 29.00 29.00
$C$17 Columbus Los Canos 0.00 0.00
$D$17 Columbus Duras 0.00 0.00
$B$18 Allentown White water 0.00 0.00
$C$18 Allentown Los Canos 28.00 28.00
$D$18 Allentown Duras 10.00 10.00

Constraints
Cell Name Cell Value Formula Status Slack
$B$23 Constraint 1 White water 35.00 $B$23=$D$23 Not Binding 0
$B$24 Constraint 2 White water 26.00 $B$24=$D$24 Not Binding 0
$B$25 Constraint 3 White water 42.00 $B$25=$D$25 Not Binding 0
$B$26 Constraint 4 White water 53.00 $B$26=$D$26 Not Binding 0
$B$27 Constraint 5 White water 29.00 $B$27=$D$27 Not Binding 0
$B$28 Constraint 6 White water 38.00 $B$28=$D$28 Not Binding 0
$B$29 Constraint 7 White water 65.00 $B$29=0 Binding 0.00
$B$14 Danville White water 0.00 $B$14>=0 Binding 0.00
$C$14 Danville Los Canos 0.00 $C$14>=0 Binding 0.00
$D$14 Danville Duras 26.00 $D$14>=0 Not Binding 26.00
$B$15 Macon White water 0.00 $B$15>=0 Binding 0.00
$C$15 Macon Los Canos 0.00 $C$15>=0 Binding 0.00
$D$15 Macon Duras 42.00 $D$15>=0 Not Binding 42.00
$B$16 Selma White water 1.00 $B$16>=0 Not Binding 1.00
$C$16 Selma Los Canos 52.00 $C$16>=0 Not Binding 52.00
$D$16 Selma Duras 0.00 $D$16>=0 Binding 0.00
$B$17 Columbus White water 29.00 $B$17>=0 Not Binding 29.00
$C$17 Columbus Los Canos 0.00 $C$17>=0 Binding 0.00
$D$17 Columbus Duras 0.00 $D$17>=0 Binding 0.00
$B$18 Allentown White water 0.00 $B$18>=0 Binding 0.00
$C$18 Allentown Los Canos 28.00 $C$18>=0 Not Binding 28.00
$D$18 Allentown Duras 10.00 $D$18>=0 Not Binding 10.00

Total Transportation cost = 35*12+26*10+42*11+1*17+52*16+29*7+28*16+10*18 = $2822
Explanation
After completing the program the following results are:
35 barrels are to be shipped from Kingsport to White water
26 barrels are to be shipped from Danville to Duras
42 barrels are to be shipped from Macon to Duras
1 barrel is to be shipped from Selma to White water
52 barrels are to be shipped from Selma to Los Canos
29 barrels are to be shipped from Columbus to White water
28 barrels are to be shipped from Allentown to Los Canos
10 barrels are to be shipped from Allentown to Duras

3. 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.
We are given transportation costs from various plants to plants and sites to sites as follows.
Kingsport Danville Macon Selma Columbus Allentown
Kingsport - 6 4 9 7 8
Danville 6 - 11 10 12 7
Macon 5 11 - 3 7 15
Selma 9 10 3 - 3 16
Columbus 7 12 7 3 - 14
Allentown 8 7 15 16 14 -

White water Los Canos Duras
White water 12 10
Los Canos 12 15
Duras 10 15

The new...

Other Papers Like Stateline Shipping

Assignment 4

589 words - 3 pages 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

Stateline Transportation Case Assignment

684 words - 3 pages + X6B +X6C = 38 X1A+ X2A+ X3A+X4A+ X5A+X6A ≤ 65 X1B+ X2B+ X3B+X4B+X5B +X6B ≤ 80 X1C+ X2C+X3C+ X4C+X5C +X6C ≤ 105 Xij > 0 Minimize Z = 2282 2.)   | Northwest Corner Method Stateline Shipping |   |   |   | | | | Plants | | | |   | Disposals | Kingsport | Danville | Macon | Selma | Columbus | Allentown | Dummy | Demand | A | 35 | 14 | 13 | 3 | 0 | 0 | 0 | 65 | B | 0 | 12 | 29 | 13 | 14 | 12 | 0 | 80 | C | 0 | 0 | 0 | 37 | 15 | 26 | 27

Freedom And Responsibility

2141 words - 9 pages Built within the Constitution of the United States are specifically defined freedoms that are guaranteed to all citizens. Conversely, with every constitutional freedom there comes a corresponding responsibility. On September 25, 1789, the state legislature’s twelve proposed amendments were transmitted by congress, the first two dealing with congressional representation and congressional pay. The following numbers three through twelve were

Hate Crime Laws

2348 words - 10 pages On June 7, 1998, 49-year-old James Byrd Jr. of Texas accepted a ride from three white men, who then beat him severely, urinated on him, chained him by his ankles to the back of their pick-up truck, dragged him for three miles into the countryside, and dumped his corpse in front of an African-American cemetery (Graczyk). A little over a year later, a jury sentenced ring leader John King to death by lethal injection (“Man Executed for Dragging

Rational Emotional Behavior Therapy Case Study Conceptualization And Treatment Plan

2140 words - 9 pages Rational Emotional Behavior Therapy Case Study of Sarah: A Conceptualization and Treatment Plan Rational emotive behavior therapy, REBT, was developed by Albert Ellis and holds the central belief that the events in our lives do not cause our disturbances but that they are instead caused by our view of the events (Murdock, 2009). Murdock (2009) states that “people are seen as responsible for their behavior” (p. 279) but, because they are

Holidays In Albania

1636 words - 7 pages Have you ever thought about having exciting and incredibly cheap vacations? Albania might be the right choice. According to My Travel Guide, Albania is ranked the fourth among ten places worth visiting in Eastern Europe (“Top 10 Eastern European Destinations”). One can encounter three kinds of vacations in this Mediterranean country: winter, summer, and cultural. The ideal places to spend your winter vacations are the Albanian Alps. They are

A Heart Of Darkness

1748 words - 7 pages In this short story, there are frequent significant subject and ideas that make the story, "A Heart of Darkness," by Joseph Conrad, and haunting novel. The main theme is absolute white power over the natives. The theme validates the corruption, and the dependence caused by the white people as they took over the Congo. White men were giving all the power; they had no self-control, and in the end they did not use wisely. The white men became

The Aspects Of Vulnerability Among The Exploited In Medical Research

2287 words - 10 pages Essentially, everyone is in some state of vulnerability. However, some of us are more susceptible to harm due to our vulnerabilities. The susceptible are the individuals with the greatest risk. These individuals risk the loss of their autonomy, and maybe even their lives. Vulnerable populations can be found in every subset of society. However, as previously mentioned, there are some vulnerable populations that are at an even greater risk than

The Hitchhiker’S Guide To The Galaxy

1171 words - 5 pages The Hitchhiker’s Guide to the Galaxy As the human race makes life-changing discoveries, it is made apparent that there is always more to learn as the universe, instead of becoming familiar, is becoming absurd. The Hitchhiker’s Guide to the Galaxy, written by Douglas Adams, as well as the 2005 film adaption, portrays absurdity to be an all-encompassing system in the universe. Through the introduction and attempt to understand lack of reason, the

The Ford Motor Company Wage Increase Of 1914 And The Theory Of Incentives And Efficiency Wages

1252 words - 6 pages ‘It’s not the employer who pays the wages. Employers only handle the money. It is the customer who pays the wages’ (Henry Ford, cited in Johnson and Weinstein 2004, p. 2). When the Ford Motor Company announced that it would more than double the wages of its workers in January 1914 to a ‘five-dollar day’ minimum, was this a contradiction to Henry Ford’s statement? If customers are actually the ultimate payers of wages, then more than

Historical Analysis Of The Economical Breakthroughs Of The Industrial Revolution

1396 words - 6 pages A Historical Analysis of the Economical Breakthroughs of the Industrial Revolution During the Industrial Revolution, many elements of society experienced huge breakthroughs that would change the way they functioned forever. Economics were definitely one of them. With many new inventions and many factories appearing, many, many, more resources were being created than ever before. Also, all of the revenue from these resources was being given to

Related Essays

Stateline Shipping Essay

540 words - 3 pages 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

Case Problem: Stateline Shipping And Transport Company

1087 words - 5 pages 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

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

385 words - 2 pages 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

Assignment # 4

599 words - 3 pages • 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