This paper circulates around the core theme of 1. In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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:
1. In Excel, or other suitable program, develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites.
2. Solve the model you developed in #1 (above) and clearly describe the results.
3. 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.
4. Solve the model you developed in #3 (above) and clearly describe the results.
5. 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.
Outcome Assessed: • Develop solutions for transshipment problems.
• Communicate issues in Management Science
Grading Rubric for Stateline Shipping & Transport Case Problem
There are 2 points in each of the five criteria for a total of 60 points possible
Criteria
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.
