## Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Tutorial
Submitted by hardik on Sat, 2013-08-10 12:59
due on Wed, 2013-08-14 12:54
hardik is willing to pay \$15.00
hardik bought 479 out of 1072 answered question(s)
More questions like this
 MAT 540 Assignment 4 Case... 2 MAT 540 Assignment 4: Case...

# MAT 540 Assignment #4: Case Problem “Stateline Shipping and Transport Company”

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

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.

Strayer MAT 540 Week 10 Assignment 4 Case Problem “Stateline Shipping and Transport Company”

Mat 540 Case Problem “Stateline Shipping and Transport Company”

Assignment Mat 540 Case Problem “Stateline Shipping and Transport Company” Solution

Solved

Mat 540 Assignment Solution

MAT540 Assignment 4 Case Problem “Stateline Shipping and Transport Company”

MAT 540 Assignment 4 Case Problem “Stateline Shipping and Transport Company”

MAT/540 Assignment 4 Case Problem “Stateline Shipping and Transport Company”

Submitted by hardik on Sat, 2013-08-10 13:00
teacher rated 99 times
4.555555
purchased 5 times
price: \$15.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 Assignment 4 Case xxxxxxx “Stateline Shipping and Transport Company”

file1.xls preview (63 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Case xxxxxxx 6 x Stateline xxxxxxxx xxx Transport xxxxxxx Sites xxxxx Kingsport Danville Macon Selma xxxxxxxx xxxxxxxxx xxxxxxxxxx xxx xxxxx Duras Supply xxxxxxx xxxxxxxxx 250 xx 19 x x 0 0 x 0 xxx 285 Danville x xxx x x 0 0 0 xx x 276 xxx Macon 0 0 214 x 0 0 x x 78 292 292 xxxxx 0 0 xx xxx 36 0 x 0 0 xxx 303 Columbus x 0 0 0 214 0 xx x 0 279 xxx xxxxxxxxx x 38 0 0 0 250 x 0 x 288 288 Whitewater 0 0 0 0 0 x xxx x 0 250 xxx xxx xxxxx 0 x 0 0 0 x x xxx x 250 xxx Duras x x x x 0 0 0 x xxx 250 250 xxxxxx xxx xxx xxx 250 xxx xxx 315 330 355 xxxxxxx 250 250 xxx 250 250 xxx 315 330 xxx xxxxx xxxx = xxxxxxx Shipping xxxxx (\$): Sites Sites xxxxxxxxx xxxxxxxx xxxxx xxxxx Columbus xxxxxxxxx xxxxxxxxxx xxx xxxxx Duras xxxxxxxxx x x 4 x x 8 12 xx 17 Danville 6 0 11 xx xx x xx x 10 Macon 5 11 x 3 7 15 13 xx 11 Selma x 10 x 0 x xx 17 16 xx xxxxxxxx 7 xx x x 0 xx x 14 12 Allentown x 7 15 xx 14 0 xx xx 18 xxxxxxxxxx 12 14 13 17 x xx 0 xx 10 xxx Canos 15 x xx xx 14 16 xx x 15 xxxxx 17 xx xx xx xx xx 10 15 x

x

# xxxxxx

x

file2.docx preview (733 words)

Case Problem “Stateline xxxxxxxx and Transport xxxxxxx”

xxxxxxx xxxxx

Instructor:

College:

Course:

xxxx

xx xxxxxxxxxxxxxx xxxxx xxx xxxxxxxx xxxxx xxxxxxxx from xxx 6 xxxxxx xx xxx 3 xxxxx disposal sites.

In attached xx Excel Spreadsheet xxx xxxxx show xxx xxxx of shipping xxx barrel xx xxxxxx from xxxx of xxx xxx xxxxxx to xxxx of the three xxxxx xxxxxxxx xxxxxx xxxxxxxx xxxx amount of waste available in the various xxxxxx xxx xxxxxxxx of xxx disposal sites.

2. Model xxx xxxxxx as follows:

I. xxx xxx xxxxxx xxxx labelled 1 xxxxxxx xx xxxxx xxx xxxxx waste xxxxxxxxxx labeled A xxxxxxx xx

II. xxxxxxxxx xxxxxxxxx Minimize x x xxxxxx + 1B(15) + xxxxxx + xxxxxx + xxxxx + xxxxxx x xxxxxx x 3B(20) + xxxxxx x 4A(17) x xxxxxx x 4C(19) + 5A(7) + 5B(14) x xxxxxx x xxxxxx + xxxxxx x xxxxxxx

xxxx xxxxxxx to:

xx x xx x 1C = 35

2A x 2B + 2C x xx

xx x 3B + 3C = 42

xx + xx + 4C = xx

xx + 5B x xx x 29

xx + xx + 6C x xx

1A + 2A + 3A x 4A + 5A + 6A ≤ 65

xx x xx + xx +

- - - more text follows - - -