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 273-274 of the text. Analyze this case, as follows:
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.
|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.|
body preview (0 words)
file1.xlsx preview (149 words)
|xxxx Problem x - xxxxxxxxx xxxxxxxx xxx xxxxxxxxx Company|
|Total Cost =x||xxxxxxx|
|xxxxxxxx xxxxx xxxx|
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