Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by murhyl on Sun, 2013-06-09 21:26
due on Thu, 2013-06-13 21:25
answered 3 time(s)
Hand shake with neel: Complete ($40.00 paid)
Hand shake with Assignment Ex...: Complete ($10.00 paid)
murhyl is willing to pay $20.00
murhyl bought 58 out of 60 answered question(s)

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:

  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.

    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.
  3. Solve the model you developed in #3 (above) and clearly describe the results.
  4. 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:
  • Develop solutions for transshipment problems.
  • Communicate issues in Management Science 
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
Submitted by hardik on Sat, 2013-08-10 11:53
teacher rated 102 times
4.52941
price: $20.00

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

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Case xxxxxxx x - xxxxxxxxx Shipping xxx Transport Company
Sites
xxxxx xxxxxxxxxxxxxxxxx xxxxxxxxxx Columbusxxxxxxxxx xxxxxxxxxxxxx xxxxx xxxxx Supplyxxxxxxx
xxxxxxxxx25016xx xx00x 0 xxx 285
Danvillex196 x0xx x800276276
xxxxxxx2140 0 00x78292 292
Selma0 0 xx xxx xx 00 x x 303303
Columbusx0 0 x xxx 0 65 xxxxxxxx
xxxxxxxxx x xx 0 x 0250 x0 xxxxxxx
xxxxxxxxxx x xx00 x 250 0 0 xxx 250
xxx xxxxx 00x x0 x 0 2500250250
xxxxx0 xx0 xx x 0 xxx250250
Demand 250 250xxx250 xxxxxx315 xxxxxx
Shippedxxx 250 xxx250 250250315 330 328
Total Cost = 2630.00
Shipping Costs ($):
Sites
Sites Kingsport xxxxxxxx MaconxxxxxxxxxxxxxAllentownWhitewaterLos CanosDuras
xxxxxxxxxx6 x 9x x xx15xx
Danville6 xxxxx12x 149 10
xxxxxxxxx x 7 xx132011
xxxxxx xxx0 x xxxx1619
xxxxxxxx 7xx 7 30 147xx xx
Allentown 8 x 15 xx 14 x 22xx 18
xxxxxxxxxx 12 14xxxxx xx x12 10
xxx Canos 159 2016 xx16xxxxx
Duras 1710 xx 19xx xx 10 xx x

xxxxxx

x

xxxxxx

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 add-on xxxxxxxx xx MS Excel

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00