Case Problem "Stateline Shipping and Transport Company"
Assignment #4: Case Problem "Stateline Shipping and Transport Company"
Read the 'Stateline Shipping and Transport Company" Case Problem on pages 273274 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: 

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% accuracy.  The objective function and constraints are specified and described with 70  79% accuracy.  The objective function and most or all constraints are specified correctly and adequately described.  The objective function and all constraints are specified correctly in the model and clearly described 
2. Solve the model given in 1 and describe the results.  Did not solve the model or adequately describe the results.  The model is solved, but its validity is questionable or it is incorrectly described.  The model is solved and the results are mostly valid and mostly correctly described.  The model is solved and the results are valid and correctly described. 
3. Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points.  Did not submit or the objective function and/or constraints are specified with less than 70% accuracy.  The objective function and constraints are specified and described with 70 79% accuracy.  The objective function and most or all constraints are specified correctly and adequately described.  The objective function and all constraints are specified correctly in the model and clearly described 
4. Solve the model given in 3 and describe the results.  Did not solve the model or adequately describe the results.  The model is solved, but its validity is questionable or it is incorrectly described.  The model is solved and the results are mostly valid and mostly correctly described.  The model is solved and the results are valid and correctly described. 
5. Interpret the models and draw conclusions  Did not complete the assignment or interpretation and/or conclusions drawn are invalid and/or not intelligibly communicated.  There are errors in interpreting the results; or inappropriate conclusions are drawn; or this is not clearly communicated.  Results are interpreted in a mostly correct manner; conclusions drawn are mostly appropriate; and communicated in a mostly clear manner.  Results are correctly interpreted; appropriate conclusions are drawn and communicated clearly. 
Answer
body preview (0 words)
file1.xlsx preview (63 words)
xxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxCase xxxxxxx x x Stateline Shipping xxx xxxxxxxxx Company  
xxxxx  
xxxxx  xxxxxxxxx  Danville  Macon  xxxxx  Columbus  Allentown  xxxxxxxxxx  xxx xxxxx  xxxxx  Supply  xxxxxxx 
xxxxxxxxx  xxx  16  19  x  0  x  0  0  x  xxx  285 
Danville  x  196  x  0  0  x  x  80  x  276  xxx 
Macon  x  x  xxx  0  0  0  0  x  xx  xxx  xxx 
Selma  x  x  17  250  36  0  0  0  0  xxx  xxx 
xxxxxxxx  0  x  0  x  214  x  xx  x  x  xxx  xxx 
Allentown  0  38  x  x  0  xxx  0  x  x  288  288 
Whitewater  x  x  0  x  0  0  xxx  x  0  xxx  xxx 
Los Canos  x  0  0  x  x  0  x  250  x  xxx  250 
Duras  0  x  0  x  0  x  0  0  250  250  250 
xxxxxx  250  250  xxx  250  xxx  xxx  xxx  330  355  
Shipped  250  xxx  250  250  xxx  xxx  315  330  328  
xxxxx xxxx =  xxxxxxx  
Shipping Costs ($):  
xxxxx  
xxxxx  xxxxxxxxx  xxxxxxxx  Macon  xxxxx  Columbus  Allentown  xxxxxxxxxx  xxx xxxxx  xxxxx  
xxxxxxxxx  0  6  x  x  x  8  12  15  xx  
Danville  6  x  xx  10  12  7  14  9  xx  
Macon  5  xx  0  x  7  xx  13  xx  xx  
Selma  x  xx  3  0  3  xx  xx  16  19  
xxxxxxxx  7  12  x  x  0  xx  x  14  12  
Allentown  x  x  15  16  14  0  xx  16  xx  
Whitewater  xx  xx  13  17  x  xx  x  12  xx  
Los Canos  15  9  20  xx  xx  16  12  x  xx  
xxxxx  xx  xx  11  19  xx  xx  xx  15  x 
Sheet2
Sheet3
file2.docx preview (1127 words)
MODEL xx xxxxxx transportation xxxxx
1) xxx xxxxx xxxxxxxxxxxxxx problem consists xx 18 decision xxxxxxxxxx xxxx symbolize the number xx barrels xx xxxxxx that xxx xxxxxxxxxxx xxxx each of xxx xxx xxxxxx xx each xx the xxxxx xxxxx disposal sites.
xxxxx xxxxx = Number xx xxxxxxx xxxxxxxxxxx per xxxx from plant ‘i’ to the jth xxxxx disposal site,
xxxxx x = 1, 2, xx xx 5, 6 and x = A, xx xx
xxxxxxxxx xxxxxxxx xx the xxxxxxx is xx xxxxxxxx xxx xxxxx xxxxxxxxxxxxxx xxxx for all xxxxxxxxx xxxxx the objective function is xxx xxx of xxx individual shipping xxxxx xxxx xxxx plant to each waste disposal site:
We xxxx to xxxxxxxx Z = xxxxxxxx xxxxxxxx xxxxxxxx 14[pic]+ xxxxxxx 10[pic]+ 13[pic]+ 20[pic] +11[pic] xxxxxxxx xxxxxxxx +19[pic] xxxxxxx xxxxxxxx +12[pic] xxxxxxxx +16[pic] +18[pic]
The xxxxxxxxxxx in xxx xxxxx xxx xxx number of barrels of xxxxxx available xxx week xx each plant and the number xx barrels of wastes xxxxxxxxxxxx xx xxxx xxxxx xxxxxxxx xxxxx There are nine xxxxxxxxxxxx one
   more text follows   
Try it before you buy it 
MAT 540  Assignment 4
body preview (0 words)
file1.xls preview (807 words)
xxxxxx xxxxxx 1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Excel xxxx Answer Report  
Worksheet: [10 Assigment x xxxxxxxxxxxxxxxxxxxxx  
Report Created: xxxxxxxxx 3:32:06 PM  
Target xxxx (Min)  
xxxx  xxxx  Original Value  Final xxxxx  
$C$13  Cost x Whitewater  0  2822  
Adjustable xxxxx  
Cell  Name  xxxxxxxx xxxxx  xxxxx xxxxx  
$C$5  xxxxxxxxx Whitewater  x  35  
$D$5  Kingsport Los xxxxx  x  0  
xxxx  xxxxxxxxx Duras  x  x  
xxxx  Danville xxxxxxxxxx  x  0  
$D$6  Danville Los xxxxx  x  0  
xxxx  Danville Duras  0  26  
xxxx  Macon xxxxxxxxxx  0  0  
$D$7  Macon xxx Canos  x  0  
$E$7  Macon xxxxx  x  42  
$C$8  Selma Whitewater  0  x  
$D$8  Selma xxx Canos  0  52  
$E$8  xxxxx xxxxx  0  x  
xxxx  xxxxxxxx xxxxxxxxxx  x  29  
xxxx  Columbus Los xxxxx  x  x  
xxxx  Columbus Duras  x  x  
xxxxx  xxxxxxxxx Whitewater  0  0  
$D$10  Allentown xxx xxxxx  x  28  
xxxxx  Allentown xxxxx  0  xx  
Constraints  
xxxx  xxxx  Cell xxxxx  Formula  xxxxxx  xxxxx 
$C$12  Shipped xxxxxxxxxx  65  xxxxx<xxxxxx  Binding  0 
xxxxx  xxxxxxx xxx xxxxx  80  xxxxx<=$D$11  xxxxxxx  x 
xxxxx  Shipped xxxxx  78  $E$12<=$E$11  Not xxxxxxx  27 
xxxx  xxxxxxxxx xxxxxxx  35  $G$5=$F$5  Not Binding  0 
xxxx  xxxxxxxx Shipped  xx  xxxxxxxxx  Not xxxxxxx  0 
$G$7  Macon Shipped  42  xxxxxxxxx  xxx xxxxxxx  0 
xxxx  Selma Shipped  53  xxxxxxxxx  Not xxxxxxx  0 
$G$9  Columbus xxxxxxx  29  xxxxxxxxx  Not Binding  0 
$G$10  xxxxxxxxx xxxxxxx  xx  xxxxxxxxxxx  xxx xxxxxxx  0 
The xxxxxxxxxxxxxx xxxxx
xxxxxxxxxx Shipping xxx Tansport Company 
x xxxxx xxx xxxxxxxx the waste directly xxxx the 6 xxxxxx to xxx 3 waste disposal 
   more text follows   
file2.doc preview (4040 words)
Running head: xxxxxxxxx SHIPPING AND TRANSPORT xxxxxxx xxx xxxx \* MERGEFORMAT xxxxxxxxxxxxxxxxx SHIPPING AND TRANSPORT COMPANY � PAGE \* MERGEFORMAT �2�
Stateline Shipping xxx Transport Company
xxxxxxx University
xxxxxx – xxxxxxxxxxxx Methods
xxxx xxx 2013
xxxxxxxxx Shipping and xxxxxxxxx xxxxxxx
Stateline xxxxxxxx xxx Transport Company wants to transport xxx chemical xxxxx from xxx xxx xxxxxx to the xxxxx xxxxxxxxxx sites and the xxx xxxxxx and xxxxx xxxxxxxx which xxxxx disposable xxxxx have has xxxx shown below. Also xxx xxxxx xxxxxxxxxx xxxxx xxx xxxxx demand requirements has been shown:
xxxxxxxxxPlants  xxxxxx (barrels) 
xx xxxxxxxxx  xx 
xx Danville  xx 
xx xxxxx  xx 
xx Selma  53 
xx Columbus  29 
6. Allentown  38 
Waste xxxxxxxx Sites  xxxxxx xxxxxxxxx 
xx xxxxxxxxxx  xx 
xx xxx xxxxx  80 
C. Duras  105 
xxx shipping costs from each xxxxxxxx xxxx to every plant have xxxx shown xxxxxx
xxxxxxxxxxxxxxPlants  Waste xxxxxxxx xxxxx  
A. Whitewater  B. Los xxxxx  C. Duras  
xx Kingsport  $12  $15  xxx 
xx Danville  xx  x  10 
xx xxxxx  xx  20  11 
xx xxxxx  xx  xx  xx 
5. Columbus  7  xx  xx 
6. Allentown  xx  xx  18 
xxxxxxxxxxxx Formulation
The xxxxxxxxx of xxxx xxxxxxx xx xx develop a xxxxxxxx xxx shipping xxxxx can minimise xxx total xxxx xx xxx xxxxxxxxxxxxxxx The objective xxxxxxxx which is Z xxxxxxxxxx the xxxx and in xxxx model the xxxxxxxx
   more text follows   
Buy this answer  Try it before you buy it 
MAT 540 Assignment 4 Case Problem “Stateline Shipping and Transport Company” [[[***** Excel Sheet Calculation + 100% correct All answer with explanation + Conclusion ******]]]
body preview (9 words)
MAT xxx xxxxxxxxxx x Case xxxxxxx “Stateline xxxxxxxx and Transport xxxxxxxxxx
file1.xls preview (63 words)
Sheet1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxCase xxxxxxx x  xxxxxxxxx Shipping xxx Transport Company  
Sites  
xxxxx  xxxxxxxxx  xxxxxxxx  xxxxx  xxxxx  Columbus  xxxxxxxxx  xxxxxxxxxx  xxx xxxxx  xxxxx  Supply  xxxxxxx 
xxxxxxxxx  250  16  xx  x  x  0  0  x  0  xxx  285 
Danville  x  196  x  0  x  x  x  80  0  276  276 
xxxxx  x  x  214  0  0  0  0  x  78  292  292 
Selma  0  0  xx  xxx  xx  0  0  x  x  303  303 
Columbus  x  0  0  x  xxx  0  65  x  x  xxx  xxx 
xxxxxxxxx  x  xx  0  x  0  250  x  0  x  xxx  xxx 
xxxxxxxxxx  x  x  x  0  0  x  250  0  0  xxx  250 
xxx xxxxx  0  0  x  x  0  x  0  250  0  250  250 
xxxxx  0  x  x  0  x  x  x  0  xxx  250  250 
Demand  250  250  xxx  250  xxx  xxx  315  xxx  xxx  
Shipped  xxx  250  xxx  250  250  250  315  330  328  
Total Cost =  2630.00  
Shipping Costs ($):  
Sites  
Sites  Kingsport  xxxxxxxx  Macon  xxxxx  xxxxxxxx  Allentown  Whitewater  Los Canos  Duras  
xxxxxxxxx  x  6  x  9  x  x  xx  15  xx  
Danville  6  x  xx  xx  12  x  14  9  10  
xxxxx  x  xx  x  x  7  xx  13  20  11  
xxxxx  x  xx  x  0  x  xx  xx  16  19  
xxxxxxxx  7  xx  7  3  0  14  7  xx  xx  
Allentown  8  x  15  xx  14  x  22  xx  18  
xxxxxxxxxx  12  14  xx  xx  x  xx  x  12  10  
xxx Canos  15  9  20  16  xx  16  xx  x  xx  
Duras  17  10  xx  19  xx  xx  10  xx  x 
xxxxxx
xxxxxxx
file2.docx preview (718 words)
xx xxxxxxxxxxxxxx Model xxx shipping xxxxx xxxxxxxx xxxx the x plants xx xxx 3 waste disposal xxxxxx
xx xxxxxxxx xx xxxxx Spreadsheet xxx xxxxx xxxxx the xxxx xx xxxxxxxx xxx barrel xx waste, from xxxx xx xxx six xxxxxx to each xx xxx three waste disposal sites, xxxxxxxx xxxx amount xx xxxxx xxxxxxxxx xx the various xxxxxx and xxxxxxxx xx xxx disposal sites.
2. Model xxx xxxxxx as follows:
I. The xxx Plants xxxx xxxxxxxx 1 xxxxxxx 6, xxxxx xxx xxxxx waste facilities labeled A xxxxxxx C.
xxx xxxxxxxxx function: Minimize x = xxxxxx x xxxxxx x 1C(17) x xxxxxx x 2B(9) + xxxxxx x 3A(13) + xxxxxx + 3C(11) x xxxxxx + 4B(16) x 4C(19) + 5A(7) + 5B(14) + xxxxxx x xxxxxx + 6B(16) + xxxxxxx
xxxx Subject xxx
1A + xx + 1C = 35
2A + xx x xx x 26
xx + 3B x xx = 42
4A + 4B x 4C x 53
5A x xx x xx x xx
6A x 6B + 6C x xx
1A x 2A x 3A + xx + xx + 6A ≤ xx
1B x 2B x 3B + xx x xx x xx ≤ xx
xx x xx x xx x xx x xx x xx ≤ 105
All xxxxxxxxxxxx ≥ 0
IV. xxxxxx addon xxxxxxxx xx MS Excel
   more text follows   
Try it before you buy it 