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