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 (149 words)
Sheet1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Problem x  xxxxxxxxx xxxxxxxx xxx xxxxxxxxx Company  
xxxxx  
xxxxx  xxxxxxxxx  Danville  xxxxx  Selma  Columbus  xxxxxxxxx  Whitewater  Los xxxxx  Duras  xxxxxx  xxxxxxx 
xxxxxxxxx  xxx  xx  xx  x  0  0  x  0  x  285  285 
xxxxxxxx  0  196  x  0  0  x  0  xx  0  xxx  xxx 
Macon  x  0  214  0  0  0  0  0  xx  292  292 
xxxxx  x  0  17  250  xx  0  x  0  0  xxx  303 
Columbus  x  0  0  x  214  x  xx  0  x  279  xxx 
Allentown  0  xx  x  x  x  250  0  0  x  xxx  288 
Whitewater  x  x  x  0  x  x  xxx  x  0  xxx  250 
Los xxxxx  0  0  x  0  0  x  x  xxx  x  250  xxx 
Duras  x  0  x  x  x  x  0  0  250  xxx  250 
xxxxxx  xxx  xxx  250  250  xxx  xxx  xxx  xxx  355  
xxxxxxx  250  250  250  250  250  250  315  330  328  
Total Cost =  xxxxxxx  
xxxxxxxx xxxxx xxxx  
Sites  
xxxxx  xxxxxxxxx  xxxxxxxx  xxxxx  xxxxx  Columbus  Allentown  Whitewater  xxx Canos  xxxxx  
xxxxxxxxx  0  6  x  9  7  8  12  xx  17  
xxxxxxxx  x  0  xx  xx  xx  7  14  x  xx  
Macon  5  xx  0  3  7  15  xx  xx  xx  
xxxxx  x  xx  3  0  3  xx  17  16  19  
Columbus  7  12  7  x  0  14  7  14  12  
Allentown  8  7  15  xx  xx  0  22  xx  xx  
xxxxxxxxxx  12  xx  xx  17  x  xx  x  xx  xx  
xxx xxxxx  xx  x  xx  xx  xx  16  12  0  15  
xxxxx  xx  10  11  xx  xx  xx  10  xx  0 
Sheet2
xxxxxx
file2.docx preview (1212 words)
MODEL xx xxxxxx xxxxxxxxxxxxxx xxxxx
xx xxx xxxxx xxxxxxxxxxxxxx xxxxxxx xxxxxxxx of xx decision xxxxxxxxxx xxxx xxxxxxxxx the number xx xxxxxxx xx xxxxxx that xxx transported xxxx xxxx of the six plants xx each of the xxxxx xxxxx disposal xxxxxx
xxxxx xxxxx = xxxxxx of Barrels transported xxx week from xxxxx ‘i’ xx the jth xxxxx disposal site,
Where x = xx 2, xx xx 5, 6 xxx j = A, xx xx
xxxxxxxxx function of xxx xxxxxxx is xx xxxxxxxx xxx xxxxx xxxxxxxxxxxxxx xxxx for xxx shipments where xxx objective xxxxxxxx xx xxx sum xx xxx xxxxxxxxxx shipping costs xxxx xxxx plant xx xxxx xxxxx xxxxxxxx site:
We xxxx xx Minimize x x xxxxxxxx xxxxxxxx xxxxxxxx 14[pic]+ 9[pic]+ 10[pic]+ 13[pic]+ 20[pic] xxxxxxxx +17[pic] +16[pic] +19[pic] xxxxxxx xxxxxxxx xxxxxxxx +22[pic] xxxxxxxx xxxxxxxx
xxx constraints in xxx xxxxx are xxx xxxxxx of xxxxxxx xx xxxxxx available xxx xxxx at each xxxxx xxx xxx number xx xxxxxxx of xxxxxx accommodated at xxxx waste disposal site. There are xxxx xxxxxxxxxxxx xxx
   more text follows   
Try it before you buy it 
MAT 540  Assignment 4
body preview (0 words)
file1.xls preview (775 words)
xxxxxx xxxxxx x
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxx xxxx xxxxxx Report  
Worksheet: [10 Assigment 4 xxxxxxxxxxxxxxxxxxxxx  
xxxxxx xxxxxxxx 8/26/2011 3:32:06 xx  
xxxxxx xxxx (Min)  
Cell  xxxx  xxxxxxxx Value  Final Value  
$C$13  xxxx = Whitewater  0  2822  
xxxxxxxxxx xxxxx  
Cell  xxxx  xxxxxxxx xxxxx  xxxxx Value  
xxxx  Kingsport Whitewater  x  35  
xxxx  Kingsport Los xxxxx  x  x  
xxxx  xxxxxxxxx Duras  x  0  
$C$6  xxxxxxxx Whitewater  x  0  
xxxx  Danville xxx xxxxx  x  0  
xxxx  xxxxxxxx xxxxx  x  26  
$C$7  xxxxx Whitewater  x  x  
$D$7  Macon Los xxxxx  x  0  
$E$7  Macon Duras  0  42  
xxxx  Selma xxxxxxxxxx  x  1  
$D$8  xxxxx xxx xxxxx  x  52  
$E$8  xxxxx Duras  0  0  
$C$9  Columbus Whitewater  0  29  
xxxx  xxxxxxxx Los xxxxx  x  x  
$E$9  Columbus xxxxx  0  x  
xxxxx  Allentown Whitewater  x  x  
$D$10  Allentown xxx Canos  x  28  
xxxxx  Allentown Duras  x  xx  
xxxxxxxxxxx  
xxxx  xxxx  Cell xxxxx  Formula  xxxxxx  xxxxx 
$C$12  Shipped Whitewater  xx  xxxxx<=$C$11  xxxxxxx  0 
$D$12  Shipped xxx xxxxx  80  xxxxx<=$D$11  Binding  0 
xxxxx  xxxxxxx 
   more text follows   
file2.doc preview (3987 words)
Running head: xxxxxxxxx xxxxxxxx AND TRANSPORT xxxxxxx xxx xxxx xx xxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxxxx AND xxxxxxxxx xxxxxxx � xxxx xx xxxxxxxxxxx xxxxxxxxx
xxxxxxxxx Shipping xxx Transport Company
xxxxxxx xxxxxxxxxxx
MAT540 – Quantitative Methods
June xxx xxxx
xxxxxxxxx xxxxxxxx and xxxxxxxxx xxxxxxx
xxxxxxxxx xxxxxxxx and xxxxxxxxx Company xxxxx to xxxxxxxxx the chemical waste xxxx its six plants to xxx xxxxx disposable sites xxx the xxx xxxxxx and their xxxxxxxx xxxxx xxxxx xxxxxxxxxx sites have has xxxx xxxxx below. Also the three xxxxxxxxxx xxxxx xxx xxxxx demand requirements xxx been xxxxxx
xxxxxxxxxxxx  xxxxxx (barrels) 
xx Kingsport  xx 
2. Danville  26 
3. Macon  xx 
4. Selma  53 
5. Columbus  xx 
6. Allentown  38 
xxxxx Disposal xxxxx  xxxxxx xxxxxxxxx 
A. xxxxxxxxxx  65 
B. Los xxxxx  xx 
C. xxxxx  xxx 
xxx xxxxxxxx costs from each xxxxxxxx xxxx to
   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 (10 words)
xxx 540 xxxxxxxxxx x Case xxxxxxx “Stateline Shipping xxx Transport Company”
file1.xls preview (149 words)
Sheet1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx x x xxxxxxxxx xxxxxxxx xxx xxxxxxxxx Company  
xxxxx  
xxxxx  xxxxxxxxx  Danville  Macon  xxxxx  xxxxxxxx  xxxxxxxxx  Whitewater  xxx Canos  xxxxx  xxxxxx  xxxxxxx 
Kingsport  xxx  16  xx  0  x  x  0  0  x  285  xxx 
Danville  x  xxx  0  0  x  0  x  80  0  xxx  xxx 
Macon  0  0  214  0  x  x  0  0  78  xxx  292 
xxxxx  x  0  xx  250  36  x  0  x  x  xxx  303 
Columbus  x  x  x  x  214  x  65  0  x  xxx  279 
xxxxxxxxx  x  38  x  0  0  xxx  0  0  0  288  xxx 
xxxxxxxxxx  x  x  x  x  0  0  250  0  0  250  250 
xxx Canos  0  0  0  0  x  0  0  250  0  250  xxx 
Duras  x  x  x  0  x  x  x  0  250  250  xxx 
Demand  250  xxx  xxx  xxx  250  250  315  330  xxx  
xxxxxxx  xxx  xxx  250  xxx  xxx  xxx  xxx  xxx  328  
Total Cost =  xxxxxxx  
xxxxxxxx xxxxx ($):  
xxxxx  
Sites  Kingsport  Danville  xxxxx  Selma  xxxxxxxx  xxxxxxxxx  Whitewater  xxx Canos  xxxxx  
Kingsport  0  6  x  9  x  8  xx  xx  xx  
Danville  6  x  11  xx  12  x  xx  9  xx  
xxxxx  x  11  x  x  7  xx  13  xx  xx  
xxxxx  x  xx  x  x  x  xx  17  xx  19  
xxxxxxxx  x  12  7  x  0  xx  7  14  12  
Allentown  x  7  15  xx  xx  x  22  16  xx  
Whitewater  xx  xx  xx  17  7  22  x  12  10  
Los Canos  15  9  20  16  xx  xx  xx  0  15  
Duras  17  10  11  19  12  xx  10  15  0 
xxxxxx
xSheet3
xfile2.docx preview (890 words)
1. xxxxxxxxxxxxxx Model xxx xxxxxxxx waste xxxxxxxx xxxx the x plants to xxx 3 waste xxxxxxxx xxxxxx
In attached MS xxxxx Spreadsheet the xxxxx xxxxx xxx cost of shipping per barrel xx xxxxxx from xxxx xx the six plants to xxxx xx xxx xxxxx xxxxx disposal xxxxxx xxxxxxxx with xxxxxx xx waste available in xxx various xxxxxx and capacity of the disposal xxxxxx
2. xxxxx xxx xxxxxx as xxxxxxxx
I. xxx xxx Plants xxxx xxxxxxxx x xxxxxxx 6, xxxxx xxx three waste facilities labeled A xxxxxxx C.
II. Objective xxxxxxxxx Minimize x = 1A(12) x xxxxxx x xxxxxx + xxxxxx x 2B(9) x xxxxxx x 3A(13) x 3B(20) x 3C(11) + xxxxxx x 4B(16) + xxxxxx + 5A(7) x 5B(14) x 5C(12) x xxxxxx x xxxxxx x xxxxxxx
III. Subject xxx
1A + 1B + 1C x 35
2A x xx + 2C = xx
3A x xx x xx x 42
4A x 4B x 4C = xx
xx + 5B x xx x xx
xx + 6B x 6C x 38
1A x xx x xx x xx x xx + xx ≤ 65
1B x xx x 3B + xx + xx + 6B ≤ xx
1C + xx + 3C + xx x 5C x xx ≤ 105
All Combinations ≥ x
xxx Solver addon solution xx MS xxxxx
   more text follows   
Try it before you buy it 