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 40 out of 41 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 Assignment Ex... on Mon, 2013-06-17 08:01
teacher rated 246 times
4.569105
purchased 2 times
price: $30.00

Answer

body preview (0 words)

file1.xlsx preview (63 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Case xxxxxxx x x Stateline Shipping xxx xxxxxxxxx Company
xxxxx
xxxxxxxxxxxxxx DanvilleMaconxxxxx Columbus Allentown xxxxxxxxxx xxx xxxxxxxxxx Supplyxxxxxxx
xxxxxxxxx xxx 16 19 x 0 x 00 xxxx 285
Danville x 196x00 x x80 x276xxx
Maconx x xxx 000 0 x xx xxxxxx
Selmaxx 17 250 36 0 000 xxx xxx
xxxxxxxx0 x 0x 214xxxx x xxxxxx
Allentown0 38xx0 xxx0xx 288288
Whitewaterxx 0 x 00 xxx x 0xxxxxx
Los Canosx 0 0xx0x250x xxx250
Duras0 x0x 0x 0 0 250250250
xxxxxx 250 250 xxx 250 xxxxxx xxx 330355
Shipped250 xxx 250250 xxx xxx 315330 328
xxxxx xxxx =xxxxxxx
Shipping Costs ($):
xxxxx
xxxxx xxxxxxxxx xxxxxxxx MaconxxxxxColumbus Allentownxxxxxxxxxx xxx xxxxxxxxxx
xxxxxxxxx 0 6x x x8 12 15 xx
Danville6xxx10 12 7149 xx
Macon5 xx0x7 xx 13 xxxx
Selma xxx 3 0 3 xxxx 1619
xxxxxxxx 7 12x x0xxx1412
Allentown xx15 16 14 0xx16 xx
Whitewaterxx xx 1317 x xx x12xx
Los Canos159 20xxxx 1612 x xx
xxxxxxx xx1119 xxxx xx 15x

Sheet2

Sheet3

file2.docx preview (1127 words)

MODEL xx xxxxxx transportation xxxxx

1) xxx xxxxx xxxxxxxxxxxxxx problem consists xx 18 decision xxxxxxxxxx xxxx symbolize the number xx barrels xx xxxxxx that xxx xxxxxxxxxxx xxxx each of xxx xxx xxxxxx xx each xx the xxxxx xxxxx disposal sites.

xxxxx xxxxx = Number xx xxxxxxx xxxxxxxxxxx per xxxx from plant ‘i’ to the jth xxxxx disposal site,

xxxxx x = 1, 2, xx xx 5, 6 and x = A, xx xx

xxxxxxxxx xxxxxxxx xx the xxxxxxx is xx xxxxxxxx xxx xxxxx xxxxxxxxxxxxxx xxxx for all xxxxxxxxx xxxxx the objective function is xxx xxx of xxx individual shipping xxxxx xxxx xxxx plant to each waste disposal site:

We xxxx to xxxxxxxx Z = xxxxxxxx xxxxxxxx xxxxxxxx 14[pic]+ xxxxxxx 10[pic]+ 13[pic]+ 20[pic] +11[pic] xxxxxxxx xxxxxxxx +19[pic] xxxxxxx xxxxxxxx +12[pic] xxxxxxxx +16[pic] +18[pic]

The xxxxxxxxxxx in xxx xxxxx xxx xxx number of barrels of xxxxxx available xxx week xx each plant and the number xx barrels of wastes xxxxxxxxxxxx xx xxxx xxxxx xxxxxxxx xxxxx There are nine xxxxxxxxxxxx one

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by neel on Tue, 2013-06-18 10:45
teacher rated 549 times
4.118395
purchased 2 times
price: $30.00

MAT 540 - Assignment 4

body preview (0 words)

file1.xls preview (807 words)

xxxxxx xxxxxx 1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxx Excel xxxx Answer Report
Worksheet: [10 Assigment x xxxxxxxxxxxxxxxxxxxxx
Report Created: xxxxxxxxx 3:32:06 PM
Target xxxx (Min)
xxxx xxxx Original ValueFinal xxxxx
$C$13Cost x Whitewater0 2822
Adjustable xxxxx
Cell Namexxxxxxxx xxxxx xxxxx xxxxx
$C$5xxxxxxxxx Whitewater x 35
$D$5 Kingsport Los xxxxxx 0
xxxxxxxxxxxxx Duras xx
xxxxDanville xxxxxxxxxx x0
$D$6 Danville Los xxxxxx 0
xxxxDanville Duras 0 26
xxxx Macon xxxxxxxxxx0 0
$D$7Macon xxx Canosx0
$E$7 Macon xxxxxx42
$C$8Selma Whitewater0x
$D$8Selma xxx Canos 052
$E$8 xxxxx xxxxx0x
xxxxxxxxxxxx xxxxxxxxxx x29
xxxxColumbus Los xxxxx x x
xxxxColumbus Duras x x
xxxxx xxxxxxxxx Whitewater 0 0
$D$10Allentown xxx xxxxx x28
xxxxx Allentown xxxxx0 xx
Constraints
xxxxxxxxCell xxxxx Formulaxxxxxx xxxxx
$C$12 Shipped xxxxxxxxxx65xxxxx<xxxxxxBinding 0
xxxxxxxxxxxx xxx xxxxx80xxxxx<=$D$11xxxxxxx x
xxxxx Shipped xxxxx 78$E$12<=$E$11Not xxxxxxx 27
xxxxxxxxxxxxx xxxxxxx35 $G$5=$F$5 Not Binding0
xxxx xxxxxxxx ShippedxxxxxxxxxxxNot xxxxxxx 0
$G$7Macon Shipped42xxxxxxxxxxxx xxxxxxx0
xxxx Selma Shipped 53xxxxxxxxx Not xxxxxxx0
$G$9Columbus xxxxxxx29xxxxxxxxxNot Binding 0
$G$10 xxxxxxxxx xxxxxxx xx xxxxxxxxxxxxxx xxxxxxx0

The xxxxxxxxxxxxxx xxxxx

x
xxxxxxxxx Shipping xxx Tansport Company
x xxxxx xxx xxxxxxxx the waste directly xxxx the 6 xxxxxx to xxx 3 waste disposal

- - - more text follows - - -

file2.doc preview (4040 words)

Running head: xxxxxxxxx SHIPPING AND TRANSPORT xxxxxxx xxx xxxx \* MERGEFORMAT xxxxxxxxxxxxxxxxx SHIPPING AND TRANSPORT COMPANY � PAGE \* MERGEFORMAT �2�

Stateline Shipping xxx Transport Company

xxxxxxx University

xxxxxx – xxxxxxxxxxxx Methods

xxxx xxx 2013

xxxxxxxxx Shipping and xxxxxxxxx xxxxxxx

Stateline xxxxxxxx xxx Transport Company wants to transport xxx chemical xxxxx from xxx xxx xxxxxx to the xxxxx xxxxxxxxxx sites and the xxx xxxxxx and xxxxx xxxxxxxx which xxxxx disposable xxxxx have has xxxx shown below. Also xxx xxxxx xxxxxxxxxx xxxxx xxx xxxxx demand requirements has been shown:

xxxxxxxxx

Plants

xxxxxx (barrels)

xx xxxxxxxxx

xx

xx Danville

xx

xx xxxxx

xx

xx Selma

53

xx Columbus

29

6. Allentown

38

xxx

Waste xxxxxxxx Sites

xxxxxx xxxxxxxxx

xx xxxxxxxxxx

xx

xx xxx xxxxx

80

C. Duras

105

xxx shipping costs from each xxxxxxxx xxxx to every plant have xxxx shown xxxxxx

xxxxxxxxxxxxxx

Plants

Waste xxxxxxxx xxxxx

A. Whitewater

B. Los xxxxx

C. Duras

xx Kingsport

$12

$15

xxx

xx Danville

xx

x

10

xx xxxxx

xx

20

11

xx xxxxx

xx

xx

xx

5. Columbus

7

xx

xx

6. Allentown

xx

xx

18

xxxxxxxxxxxx Formulation

The xxxxxxxxx of xxxx xxxxxxx xx xx develop a xxxxxxxx xxx shipping xxxxx can minimise xxx total xxxx xx xxx xxxxxxxxxxxxxxx The objective xxxxxxxx which is Z xxxxxxxxxx the xxxx and in xxxx model the xxxxxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by hardik on Sat, 2013-08-10 11:53
teacher rated 77 times
4.636365
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