## Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by 123lynda on Tue, 2013-09-03 22:36
due on Thu, 2013-09-05 22:34
Hand shake with MathematicsEx...: In progress
123lynda is willing to pay \$10.00
123lynda bought 10 out of 13 answered question(s)
More questions like this
 math 540 5 MAT540 WEEK10 Assignment

# Assignment 4 "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.

Submitted by Assignment Ex... on Tue, 2013-09-03 22:41
teacher rated 247 times
4.554655
purchased one time
price: \$15.00

body preview (0 words)

file1.docx preview (1127 words)

MODEL 1: xxxxxx transportation model

xx The xxxxx transportation xxxxxxx consists of 18 decision xxxxxxxxxx xxxx xxxxxxxxx the xxxxxx of xxxxxxx xx xxxxxx xxxx are transported from each xx xxx xxx plants to xxxx of xxx three xxxxx disposal xxxxxx

Here, xxxxx = xxxxxx xx xxxxxxx transported per xxxx from xxxxx ‘i’ xx the jth xxxxx disposal xxxxx

Where i x 1, 2, xx xx xx 6 and j x xx xx C.

xxxxxxxxx xxxxxxxx xx xxx manager is xx minimize xxx total xxxxxxxxxxxxxx cost for xxx shipments xxxxx xxx xxxxxxxxx function is the sum xx the individual xxxxxxxx costs from xxxx plant to xxxx waste disposal site:

We need xx Minimize x = 12[pic]+ xxxxxxxx 17[pic]+ 14[pic]+ 9[pic]+ 10[pic]+ 13[pic]+ 20[pic] xxxxxxxx +17[pic] +16[pic] xxxxxxxx xxxxxxx +14[pic] +12[pic] xxxxxxxx xxxxxxxx xxxxxxxx

The constraints xx xxx model are the number of barrels xx wastes available xxx xxxx xx xxxx plant xxx xxx number xx barrels xx xxxxxx xxxxxxxxxxxx xx xxxx xxxxx xxxxxxxx xxxxx xxxxx xxx xxxx xxxxxxxxxxxx xxx

- - - more text follows - - -

file2.xlsx preview (63 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Case xxxxxxx x x Stateline xxxxxxxx xxx xxxxxxxxx xxxxxxx Sites xxxxx Kingsport Danville xxxxx xxxxx xxxxxxxx Allentown Whitewater Los xxxxx Duras xxxxxx xxxxxxx xxxxxxxxx xxx xx 19 x 0 0 0 0 x xxx xxx xxxxxxxx 0 196 x 0 x x x 80 x xxx xxx xxxxx x 0 xxx x x 0 0 x 78 292 xxx xxxxx 0 0 xx xxx 36 0 x 0 x xxx xxx xxxxxxxx 0 0 x 0 214 0 xx x 0 279 xxx Allentown x 38 x 0 x 250 x x 0 288 288 xxxxxxxxxx x x x x 0 0 250 0 0 xxx 250 Los xxxxx 0 0 0 x x 0 x xxx x xxx 250 Duras x x x 0 0 x x x xxx xxx xxx Demand xxx xxx 250 xxx xxx 250 315 330 xxx Shipped 250 xxx 250 250 250 250 xxx 330 328 Total xxxx = xxxxxxx xxxxxxxx xxxxx (\$): xxxxx xxxxx xxxxxxxxx Danville Macon xxxxx xxxxxxxx Allentown xxxxxxxxxx xxx Canos xxxxx Kingsport x 6 4 9 7 8 12 15 xx xxxxxxxx 6 x xx 10 xx 7 xx x 10 Macon x xx x x 7 15 xx 20 11 xxxxx x xx x 0 3 xx 17 16 19 Columbus x xx x 3 x xx 7 xx 12 xxxxxxxxx 8 x xx 16 14 x xx xx 18 Whitewater xx xx 13 17 x 22 0 12 xx Los Canos xx x xx xx xx xx 12 x xx xxxxx 17 10 11 19 xx 18 10 15 0

# Sheet3

Submitted by hardik on Mon, 2013-12-16 03:55
teacher rated 83 times
4.66265
purchased one time
price: \$10.00

## MAT 540 Assignment #4: Case Problem “Stateline Shipping and Transport Company” [***** Excel Sheet Calculation + 100% correct All answer with explanation + Conclusion + APA Format******]

body preview (2 words)

MAT xxx xxxxxxxxxx xxx

file1.xls preview (63 words)

# Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxx xxxxxxx 6 x Stateline Shipping and Transport Company xxxxx xxxxx xxxxxxxxx Danville xxxxx xxxxx xxxxxxxx Allentown xxxxxxxxxx Los Canos Duras xxxxxx xxxxxxx xxxxxxxxx xxx xx xx 0 x x 0 0 0 xxx xxx xxxxxxxx x 196 x x x x 0 80 0 276 276 Macon x 0 214 0 x x 0 0 78 xxx 292 Selma x x xx 250 36 0 0 0 x xxx xxx xxxxxxxx 0 0 x 0 xxx 0 65 x x xxx 279 xxxxxxxxx 0 xx 0 x x 250 0 0 0 xxx xxx Whitewater 0 0 0 0 x 0 xxx x x xxx 250 Los Canos 0 x x 0 x x x 250 0 xxx 250 Duras x 0 x x 0 x x 0 xxx xxx 250 xxxxxx xxx 250 xxx 250 xxx xxx xxx xxx 355 Shipped 250 250 xxx 250 250 250 xxx xxx xxx xxxxx Cost = xxxxxxx xxxxxxxx Costs (\$): xxxxx xxxxx xxxxxxxxx Danville xxxxx Selma Columbus Allentown xxxxxxxxxx Los Canos Duras xxxxxxxxx 0 x 4 9 x 8 12 15 17 xxxxxxxx 6 0 xx 10 xx 7 14 9 10 xxxxx x 11 0 x x 15 xx xx xx xxxxx 9 xx x x 3 16 17 xx 19 xxxxxxxx x xx 7 3 0 14 x xx xx Allentown x x xx 16 xx 0 22 xx 18 Whitewater 12 xx xx 17 x 22 0 12 10 xxx Canos xx x xx xx xx 16 xx 0 15 Duras 17 xx xx 19 12 18 xx xx 0

x

# xxxxxx

file2.docx preview (733 words)

xxxx Problem “xxxxxxxxx xxxxxxxx xxx Transport Company”

xxxxxxx xxxxx

xxxxxxxxxxx

College:

Course:

xxxx

1. xxxxxxxxxxxxxx xxxxx xxx shipping xxxxx xxxxxxxx from the 6 plants xx xxx 3 xxxxx xxxxxxxx sites.

xx xxxxxxxx xx Excel xxxxxxxxxxx xxx xxxxx xxxx xxx cost xx xxxxxxxx per xxxxxx of waste, from each xx the xxx plants to each of xxx three xxxxx disposal xxxxxx together with xxxxxx xx xxxxx available xx the various plants xxx capacity xx the xxxxxxxx sites.

xx Model was solved as follows:

I. xxx six xxxxxx xxxx xxxxxxxx 1 through 6, xxxxx the xxxxx waste xxxxxxxxxx labeled A xxxxxxx C.

II. xxxxxxxxx function: Minimize x = 1A(12) + 1B(15) x xxxxxx x xxxxxx + 2B(9) + xxxxxx x xxxxxx + xxxxxx + xxxxxx x xxxxxx + 4B(16) + 4C(19) + xxxxx + xxxxxx x xxxxxx x 6A(22) x 6B(16) + 6C(18);

xxxx xxxxxxx to:

xx + 1B x xx = xx

xx + xx x xx x 26

3A x xx x 3C x xx

xx + xx x 4C = 53

5A + 5B x 5C x xx

6A x 6B + xx x xx

xx x 2A x 3A x xx x 5A + xx ≤ xx

1B x xx x xx x

- - - more text follows - - -

Submitted by jam007 on Wed, 2013-09-04 01:53
teacher rated 111 times
4.83784
purchased one time
price: \$10.00

## Solution to "Stateline Shipping and Transport Company from jam007

body preview (4 words)

xxxxxx see xxx attachment

file1.doc preview (1429 words)

xxx Original problem

xxx xxxxxxx xxx be xxxxxxxx xx a Transportation xxxxxxx for xxxx xxxxxxxxxxxxx xxx problem is that the xxxxxxx xxx xxx xxxxxxxxxx centres from xxxxx company wants xx collect waste xxx xxxx xxxxxxxxxxx xx three disposable centres xx a minimum xxxxx The xxxxxxxxx costs xxxx collection centres to disposable xxxxx xxx xxxxx xx a table as shown xx xxx following table.

xxxxxxxxxxxxxxxx
 xxxxx water xxx Canos xxxxx xxxxxxxxxxxx (bbl) Kingsport \$12.00 \$15.00 \$17.00 35 Danville \$14.00 xxxxx \$10.00 26 Macon xxxxxx xxxxxx xxxxxx xx Selma \$17.00 \$16.00 xxxxxx xx xxxxxxxx xxxxx xxxxxx xxxxxx xx xxxxxxxxx \$22.00 \$16.00 xxxxxx 38 Capacity (barrels) xx xx 105

xxxxx in the xxxxxxxxxxxx form:

Let Xij i=1,2,3,4,5,6; xxxxxxx xxxxxx the quantity xx waste xxxxxxxxxxx from xxxx xxxxx xx xxxx xxxxx disposal centre. xxx xxxxxxxxx xxxxxxxx Z xxx xxxxxxxxxxx can be expressed xxx

Minimize Z=12X11+15X12+17X13+14X21+9X22+10X23+13X31+20X32+11X33+17X41+16X42+19X43+7X51+14X52+12X53+22X61+16X62+18X63

xxxxxxx to

X11+X12+X13=35

xxxxxxxxxxxxxxx

xxxxxxxxxxxxxxx

X41+X42+X43=53

X51+X52+X53=29

X61+X62+X63=38

X11+X21+X31+X41+X51+X6165

X12+X22+X32+X42+X52+X6280

xxxxxxxxxxxxxxxxxxxxxxxxxxx

Xij 0, xxxxxxxxxxxxxx j=1,2,3.

xxx The xxxxxxxx xx the Original Problem

The xxxxx problem xxxxxxx xxxxxxxxxxx xxx intermediates sites xxx xxxxxx xxxxx xxxxx xxxxxx xxx the xxxxx xxxxxxxx are given xx

- - - more text follows - - -

file2.xlsx preview (105 words)

# xxxxxxxx problem

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 X11 xxx xxx xxx X22 xxx xxx xxx xxx xxx xxx xxx X51 xxx xxx xxx X62 xxx LHS xxxx RHS xxxxxxxx 12 xx xx xx x xx xx xx 11 17 xx xx x xx xx xx 16 18 Kingspor 1 1 1 35 x 35 Danville 1 x x xx x 26 xxxxx 1 1 x xx x 42 Selma 1 x x 53 = xx Columbu x x x 29 = 29 Allentow x 1 x 38 x xx xxxxxxxxxx x 1 x x 1 1 65 <= xx xxx Canos 1 x x x 1 1 xxxxxxxxxxxxx <= 80 Duras x 1 x 1 x 1 xxxxxxxxxxxxx <= xxx Solution xx x 0 0 x 26 0 x xx x xx x xx 0 0 x 27.9999999385 10.0000000615 xxxxxxxxxxxxxxx Z Whitewater xxx Canos Duras xxxxxxxxxxxx xxxxx Kingsport xx xx 17 35 xxxxxxxx 14 9 xx 26 xxxxx 13 xx xx 42 xxxxx 17 xx 19 xx xxxxxxxx 7 xx xx 29 Allentown xx xx xx 38 xxxxxxxx xxxxxxxxx 65 80 105

# Modified problem

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxx xxx xxx xxx xxx X23 xxx X32 xxx xxx X42 X43 xxx X52 X53 xxx X62 X63 xxx xxxx xxx xxxxxxxx 12 15 xx xx x 10 13 19 xx xx 16 xx x 14 12 20 16 17 xxxxxxxx x x 1 xx = 35 Danville x x 1 xx x xx xxxxx 1 x 1 xx = xx xxxxx 1 1 1 53.000000477 = 53 Columbu 1 x 1 29 = xx xxxxxxxx x x x 38 x xx xxxxxxxxxx 1 x 1 x 1 x 65.0000000285