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 123lynda on Tue, 2013-09-03 22:36
due on Thu, 2013-09-05 22:34
answered 3 time(s)
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.

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

Answer For You

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
xxxxxKingsportDanvillexxxxxxxxxx xxxxxxxxAllentown Whitewater Los xxxxx Durasxxxxxx xxxxxxx
xxxxxxxxxxxx xx 19 x00 0 0x xxxxxx
xxxxxxxx 0196x 0 x xx 80 xxxx xxx
xxxxx x0xxxxx00x78 292xxx
xxxxx 0 0 xx xxx360x0 xxxxxxx
xxxxxxxx0 0x 0214 0 xxx0279xxx
Allentown x38x0 x250x x 0288288
xxxxxxxxxx x x x x0 0250 0 0 xxx 250
Los xxxxx00 0x x0xxxxx xxx 250
Durasx x x00 xxx xxxxxx xxx
Demand xxx xxx 250 xxx xxx250 315 330xxx
Shipped250 xxx250250250250 xxx330 328
Total xxxx = xxxxxxx
xxxxxxxx xxxxx ($):
xxxxx
xxxxx xxxxxxxxxDanville Macon xxxxx xxxxxxxxAllentownxxxxxxxxxxxxx Canos xxxxx
Kingsportx 6 49 7 812 15xx
xxxxxxxx6 xxx10 xx 7 xxx 10
Maconx xx xx715 xx 20 11
xxxxxx xx x0 3xx 171619
Columbus xxxx 3 xxx7xx 12
xxxxxxxxx8x xx 16 14 x xx xx18
Whitewater xx xx 13 17 x22 012 xx
Los Canosxxx xxxxxxxx12xxx
xxxxx1710 11 19xx 1810150

xxxxxx

Sheet3


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by hardik on Mon, 2013-12-16 03:55
teacher rated 81 times
4.65432
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
xxxxxxxxxxxxxx Danville xxxxxxxxxx xxxxxxxx Allentown xxxxxxxxxx Los Canos Durasxxxxxxxxxxxxx
xxxxxxxxx xxxxx xx 0x x00 0 xxxxxx
xxxxxxxxx196xxxx0 800 276 276
Maconx 0 2140 x x00 78 xxx 292
Selma xxxx 25036 000 x xxx xxx
xxxxxxxx0 0 x 0xxx 065 xxxxx 279
xxxxxxxxx 0 xx0 x x 25000 0 xxx xxx
Whitewater0000 x0 xxxx x xxx 250
Los Canos 0xx0xx x 250 0xxx 250
Duras x 0xx 0x x0 xxx xxx 250
xxxxxx xxx250 xxx 250xxxxxxxxxxxx355
Shipped250 250xxx250250 250xxx xxxxxx
xxxxx Cost = xxxxxxx
xxxxxxxx Costs ($):
xxxxx
xxxxx xxxxxxxxx Danville xxxxx SelmaColumbus Allentownxxxxxxxxxx Los CanosDuras
xxxxxxxxx 0x 49 x 812 1517
xxxxxxxx 60 xx 10 xx 714 9 10
xxxxxx11 0xx 15 xx xxxx
xxxxx9xx xx3 1617xx 19
xxxxxxxx x xx7 3014 x xx xx
Allentownxxxx 16xx 022xx 18
Whitewater 12xxxx17x 22 01210
xxx Canosxx x xx xx xx16xx 0 15
Duras17xx xx19 1218 xxxx0

Sheet2

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


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by jam007 on Wed, 2013-09-04 01:53
teacher rated 109 times
4.83486
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 xxxxxxxxx X22xxxxxx xxxxxxxxxxxx xxx X51 xxx xxx xxxX62 xxx LHSxxxx RHS
xxxxxxxx12xx xx xx x xxxx xx 11 17xxxxx xxxxxx 1618
Kingspor11135 x35
Danville1 xx xx x26
xxxxx 11x xx x 42
Selma1x x 53= xx
Columbu xx x29 =29
Allentow x 1x38 xxx
xxxxxxxxxxx1 x x 11 65<=xx
xxx Canos 1xx x11xxxxxxxxxxxxx<= 80
Durasx 1 x1 x 1xxxxxxxxxxxxx<= xxx
Solutionxxx 0 0x26 0xxxx xx xxx 00x27.9999999385 10.0000000615 xxxxxxxxxxxxxxx
Z
Whitewater xxx Canos Duras xxxxxxxxxxxx xxxxx
Kingsportxx xx17 35
xxxxxxxx14 9xx26
xxxxx 13xx xx42
xxxxx17xx 19 xx
xxxxxxxx7 xx xx 29
Allentown xx xx xx 38
xxxxxxxx xxxxxxxxx 65 80105

Modified problem

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxx xxxxxxX23xxx X32xxx xxxX42X43xxx X52X53 xxx X62 X63xxxxxxx xxx
xxxxxxxx12 15xx xxx10 13 19 xxxx16xx x 1412 20 1617
xxxxxxxxxx 1xx= 35
Danvillex x 1 xx x xx
xxxxx1 x1 xx =xx
xxxxx 1 11 53.000000477= 53
Columbu1x 1 29 = xx
xxxxxxxxx x x38x xx
xxxxxxxxxx1 x1 x 1 x65.0000000285<x65
xxx xxxxxxxx 1x 1 xx<= xx
Duras1 x1xx1 xxxxxxxxxxxxx <x xxx
Solution 0.0000008126xx xxxxxxxxxxxxx0 260 x 0xx xxxxxxxxxxxxx x xxxxxxxxxxxxx 29 x00380xxxxxxxxxxxxxxx
Optimal xxxx = xxxxxWhite water Los xxxxx Duras
Kingport xxxx
Danvillexx
xxxxx 42
xxxxxx xx xx
Columbus 29
Allentown 38
Dummy 27


Buy this answer

Try it before you buy it
Check plagiarism for $2.00