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 22 out of 22 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 239 times
4.598325
purchased 2 times
price: $30.00

Answer

body preview (0 words)

file1.xlsx preview (149 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxx Problem x - xxxxxxxxx xxxxxxxx xxx xxxxxxxxx Company
xxxxx
xxxxx xxxxxxxxx DanvillexxxxxSelmaColumbusxxxxxxxxxWhitewaterLos xxxxxDuras xxxxxx xxxxxxx
xxxxxxxxx xxx xx xx x 00x0x285285
xxxxxxxx0 196x 0 0 x 0 xx0xxx xxx
Maconx 0 2140 0 000xx292 292
xxxxxx 017 250xx0x 00xxx303
Columbus x 0 0x 214x xx 0 x 279xxx
Allentown 0xxxx x250 0 0x xxx288
Whitewater x x x0 xx xxx x0 xxx250
Los xxxxx 00 x 00 x xxxxx 250 xxx
Durasx0x x xx 00250 xxx 250
xxxxxxxxx xxx 250 250xxx xxxxxx xxx 355
xxxxxxx250 250 250250 250 250315 330 328
Total Cost =xxxxxxx
xxxxxxxx xxxxx xxxx
Sites
xxxxx xxxxxxxxxxxxxxxxx xxxxx xxxxx ColumbusAllentownWhitewater xxx Canosxxxxx
xxxxxxxxx06x 9 7 812 xx17
xxxxxxxx x0 xxxxxx714 x xx
Macon5xx0 3 7 15xx xx xx
xxxxxxxx 303xx17 16 19
Columbus 712 7 x 0 14714 12
Allentown8 715xxxx 0 22 xx xx
xxxxxxxxxx12xxxx 17xxx x xxxx
xxx xxxxxxx x xx xxxx 16120 15
xxxxxxx1011 xxxx xx 10xx0

Sheet2

xxxxxx

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


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 536 times
4.162315
purchased 2 times
price: $30.00

MAT 540 - Assignment 4

body preview (0 words)

file1.xls preview (775 words)

xxxxxx xxxxxx x

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxx xxxxx xxxx xxxxxx Report
Worksheet: [10 Assigment 4 xxxxxxxxxxxxxxxxxxxxx
xxxxxx xxxxxxxx 8/26/2011 3:32:06 xx
xxxxxx xxxx (Min)
Cell xxxx xxxxxxxx Value Final Value
$C$13 xxxx = Whitewater0 2822
xxxxxxxxxx xxxxx
Cellxxxxxxxxxxxx xxxxx xxxxx Value
xxxxKingsport Whitewaterx35
xxxxKingsport Los xxxxxx x
xxxxxxxxxxxxx Durasx 0
$C$6xxxxxxxx Whitewater x 0
xxxx Danville xxx xxxxxx0
xxxx xxxxxxxx xxxxxx26
$C$7xxxxx Whitewater x x
$D$7Macon Los xxxxx x0
$E$7 Macon Duras 042
xxxx Selma xxxxxxxxxx x1
$D$8xxxxx xxx xxxxx x 52
$E$8xxxxx Duras00
$C$9Columbus Whitewater029
xxxxxxxxxxxx Los xxxxxx x
$E$9 Columbus xxxxx0x
xxxxx Allentown Whitewaterx x
$D$10Allentown xxx Canos x28
xxxxxAllentown Duras xxx
xxxxxxxxxxx
xxxx xxxx Cell xxxxx Formulaxxxxxxxxxxx
$C$12Shipped Whitewater xx xxxxx<=$C$11 xxxxxxx 0
$D$12Shipped xxx xxxxx80 xxxxx<=$D$11 Binding0
xxxxx xxxxxxx

- - - more text follows - - -

file2.doc preview (3987 words)

Running head: xxxxxxxxx xxxxxxxx AND TRANSPORT xxxxxxx xxx xxxx xx xxxxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxxxx AND xxxxxxxxx xxxxxxx � xxxx xx xxxxxxxxxxx xxxxxxxxx

xxxxxxxxx Shipping xxx Transport Company

xxxxxxx xxxxxxxxxxx

MAT540 – Quantitative Methods

June xxx xxxx

xxxxxxxxx xxxxxxxx and xxxxxxxxx xxxxxxx

xxxxxxxxx xxxxxxxx and xxxxxxxxx Company xxxxx to xxxxxxxxx the chemical waste xxxx its six plants to xxx xxxxx disposable sites xxx the xxx xxxxxx and their xxxxxxxx xxxxx xxxxx xxxxxxxxxx sites have has xxxx xxxxx below. Also the three xxxxxxxxxx xxxxx xxx xxxxx demand requirements xxx been xxxxxx

xxxxxx

xxxxxx

xxxxxx (barrels)

xx Kingsport

xx

2. Danville

26

3. Macon

xx

4. Selma

53

5. Columbus

xx

6. Allentown

38

xxxx

xxxxx Disposal xxxxx

xxxxxx xxxxxxxxx

A. xxxxxxxxxx

65

B. Los xxxxx

xx

C. xxxxx

xxx

xxx xxxxxxxx costs from each xxxxxxxx xxxx to

- - - 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 47 times
4.51064
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 (10 words)

xxx 540 xxxxxxxxxx x Case xxxxxxx “Stateline Shipping xxx Transport Company”

file1.xls preview (149 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxx xxxxxxx x x xxxxxxxxx xxxxxxxx xxx xxxxxxxxx Company
xxxxx
xxxxx xxxxxxxxxDanvilleMacon xxxxx xxxxxxxxxxxxxxxxxWhitewaterxxx Canosxxxxx xxxxxx xxxxxxx
Kingsport xxx 16 xx 0xx 0 0 x285xxx
Danville x xxx00 x 0x800xxx xxx
Macon002140 xx 00 78xxx292
xxxxx x 0xx250 36x0 xxxxx 303
Columbusx xx x214 x 65 0 x xxx 279
xxxxxxxxxx38 x 0 0xxx 00 0288 xxx
xxxxxxxxxxx xxx00 250 00 250 250
xxx Canos 0000 x 0 0 250 0 250xxx
Duras x x x 0xxx0 250 250 xxx
Demand250xxx xxxxxx 250 250 315330xxx
xxxxxxx xxxxxx250xxxxxx xxxxxx xxx328
Total Cost = xxxxxxx
xxxxxxxx xxxxx ($):
xxxxx
SitesKingsport Danville xxxxxSelmaxxxxxxxxxxxxxxxxx Whitewaterxxx Canosxxxxx
Kingsport06 x9 x8xxxxxx
Danville6x11xx 12 xxx 9 xx
xxxxx x11x x 7xx13xxxx
xxxxxx xx xx x xx17 xx19
xxxxxxxxx12 7x0xx71412
Allentown x 715xx xx x22 16 xx
Whitewater xxxxxx17722 x1210
Los Canos 159 20 16 xx xxxx015
Duras17 10 11 1912 xx 1015 0

xxxxxx

x

Sheet3

x

file2.docx preview (890 words)

1. xxxxxxxxxxxxxx Model xxx xxxxxxxx waste xxxxxxxx xxxx the x plants to xxx 3 waste xxxxxxxx xxxxxx

In attached MS xxxxx Spreadsheet the xxxxx xxxxx xxx cost of shipping per barrel xx xxxxxx from xxxx xx the six plants to xxxx xx xxx xxxxx xxxxx disposal xxxxxx xxxxxxxx with xxxxxx xx waste available in xxx various xxxxxx and capacity of the disposal xxxxxx

2. xxxxx xxx xxxxxx as xxxxxxxx

I. xxx xxx Plants xxxx xxxxxxxx x xxxxxxx 6, xxxxx xxx three waste facilities labeled A xxxxxxx C.

II. Objective xxxxxxxxx Minimize x = 1A(12) x xxxxxx x xxxxxx + xxxxxx x 2B(9) x xxxxxx x 3A(13) x 3B(20) x 3C(11) + xxxxxx x 4B(16) + xxxxxx + 5A(7) x 5B(14) x 5C(12) x xxxxxx x xxxxxx x xxxxxxx

III. Subject xxx

1A + 1B + 1C x 35

2A x xx + 2C = xx

3A x xx x xx x 42

4A x 4B x 4C = xx

xx + 5B x xx x xx

xx + 6B x 6C x 38

1A x xx x xx x xx x xx + xx ≤ 65

1B x xx x 3B + xx + xx + 6B ≤ xx

1C + xx + 3C + xx x 5C x xx ≤ 105

All Combinations ≥ x

xxx Solver add-on solution xx MS xxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00