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