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 19:36
due on Thu, 2013-09-05 19:34
answered 3 time(s)
Hand shake with MathematicsEx...: In progress
123lynda is willing to pay $10.00
123lynda bought 10 out of 12 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 19:41
teacher rated 239 times
4.598325
purchased one time
price: $15.00

Answer For You

body preview (0 words)

file1.docx preview (1212 words)

xxxxx xx xxxxxx xxxxxxxxxxxxxx xxxxx

xx The xxxxx transportation problem xxxxxxxx xx xx decision variables. They symbolize xxx number of xxxxxxx of wastes xxxx xxx xxxxxxxxxxx xxxx xxxx of the xxx xxxxxx to each of xxx three xxxxx disposal xxxxxx

xxxxx [pic] = Number of xxxxxxx xxxxxxxxxxx xxx xxxx from xxxxx ‘i’ xx the jth waste xxxxxxxx site,

Where i x 1, xx xx 4, 5, 6 and x x A, xx C.

Objective function of the xxxxxxx is xx xxxxxxxx the total xxxxxxxxxxxxxx cost xxx all shipments xxxxx xxx objective xxxxxxxx xx the sum of xxx individual shipping xxxxx from each plant to xxxx waste xxxxxxxx site:

xx xxxx xx xxxxxxxx Z = xxxxxxxx 15[pic]+ xxxxxxxx xxxxxxxx xxxxxxx xxxxxxxx 13[pic]+ xxxxxxx +11[pic] xxxxxxxx xxxxxxxx +19[pic] xxxxxxx xxxxxxxx xxxxxxxx +22[pic] +16[pic] +18[pic]

xxx constraints xx xxx model are xxx number of xxxxxxx of wastes xxxxxxxxx xxx xxxx xx each plant and the xxxxxx xx barrels xx wastes xxxxxxxxxxxx at each xxxxx xxxxxxxx site. xxxxx xxx xxxx constraints, one

- - - more text follows - - -

file2.xlsx preview (139 words)

xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxx xxxxxxx 6 x Stateline xxxxxxxx and xxxxxxxxx xxxxxxx
xxxxx
SitesKingsportxxxxxxxxxxxxx xxxxx Columbusxxxxxxxxxxxxxxxxxxx Los xxxxx DurasSupplyxxxxxxx
Kingsport xxx 16xx0 0x0 0 xxxx285
xxxxxxxx x 1960 0 x 0 0 xxxxxx xxx
xxxxx0 x xxx xxx 0 078 292xxx
xxxxx x xxx xxx xx 0 x 0 x 303 303
Columbus0 0xx214 0xx 0 0xxxxxx
Allentown 0 xx 00 0xxx000xxxxxx
xxxxxxxxxx 0xx0 00 2500 0 xxxxxx
Los xxxxxxx x0 x 0 0 xxxxxxx 250
Durasx0 0 00xx x 250 xxx 250
xxxxxx 250250xxx250xxxxxx315330 xxx
xxxxxxx xxxxxx 250250 250 xxx315 330xxx
xxxxx xxxx x 2630.00
Shipping xxxxx ($):
Sites
Sitesxxxxxxxxx Danville xxxxx Selmaxxxxxxxx Allentown WhitewaterLos xxxxxxxxxx
Kingsportx xxxxxxxxx 17
Danville x 011 10xxx14910
xxxxx x 11 0x 7xxxx xx xx
xxxxx x103 x3 16 xx 16xx
Columbusxxxx x 0xx 71412
xxxxxxxxx8x xx xx14 0 xx xxxx
Whitewater xx 14 13 xx 7 220xx10
Los Canosxx x 20xx xx16 12 015
xxxxxxxxx xxxxxx xx xx xx0

Sheet2

xxxxxx


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by hardik on Mon, 2013-12-16 00:55
teacher rated 48 times
4.520835
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 (3 words)

MAT 540 xxxxxxxxxx xxx

file1.xls preview (150 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Case xxxxxxx x - xxxxxxxxx xxxxxxxx and Transport xxxxxxx
xxxxx
SitesxxxxxxxxxDanvillexxxxx xxxxx xxxxxxxxAllentown WhitewaterLos xxxxxDurasSupply xxxxxxx
Kingsport 250 16 xx xx 0 0x 0 xxx xxx
Danville0 xxx0 0 00x 80xxxx276
Maconxx xxx0x 00078292 xxx
xxxxx 0 xxx 250xx 0x00xxx 303
Columbus 0 00x 2140 xxxx xxxxxx
Allentown0 38 x x x250x 0 x 288xxx
xxxxxxxxxxx x 00 xxxxx x 0 250250
Los xxxxx00x 0 x00xxx0 250 250
Duras 0 0 0 x0 x x0 xxx 250xxx
Demand 250250xxx250250xxx315330 xxx
Shipped xxxxxxxxxxxxxxxxxx xxx xxx 328
xxxxx xxxx = xxxxxxx
Shipping xxxxx xxxx
Sites
Sites Kingsport DanvilleMaconxxxxxxxxxxxxxAllentownxxxxxxxxxxxxx Canos Duras
xxxxxxxxx 0 6x 9 7 x12xx xx
xxxxxxxx 6 x11 10 127 xx9 xx
xxxxx x xx 037 xx xx2011
Selma9xx3 0 x 1617 xxxx
Columbus 7 xxxx 0xx 7xxxx
xxxxxxxxx8 71516 xx0 xxxxxx
xxxxxxxxxx12xx1317 xxx 0xx 10
xxx Canos xx 92016xx 16 xx0xx
xxxxxxxxx11 19 xx xxxxxxx

Sheet2

x

Sheet3

file2.docx preview (876 words)

xxxx Problem “xxxxxxxxx Shipping and xxxxxxxxx Company”

xxxxxxx Name:

Instructor:

xxxxxxxx

xxxxxxx

Date

1. Transportation xxxxx for xxxxxxxx xxxxx directly xxxx the 6 plants to xxx 3 waste disposal sites.

In attached xx Excel xxxxxxxxxxx the xxxxx show xxx xxxx of shipping xxx xxxxxx xx waste, from xxxx xx xxx six plants to each xx the xxxxx xxxxx disposal sites, together with amount of waste xxxxxxxxx in the various plants and capacity xx xxx disposal sites.

2. Model xxx xxxxxx as xxxxxxxx

I. The xxx Plants were xxxxxxxx x xxxxxxx xx while xxx three waste facilities labeled x through C.

xxx xxxxxxxxx xxxxxxxxx Minimize x x xxxxxx x 1B(15) + xxxxxx + 2A(14) x xxxxx + xxxxxx + xxxxxx x xxxxxx x 3C(11) x xxxxxx x xxxxxx + 4C(19) + 5A(7) + xxxxxx + xxxxxx + xxxxxx + 6B(16) + xxxxxxx

xxxx xxxxxxx xxx

xx + 1B + 1C x 35

xx + 2B + 2C = 26

xx + xx + 3C = 42

4A x 4B + xx = 53

xx x 5B + 5C = xx

6A x xx + 6C = 38

xx + xx + xx + 4A + xx x 6A ≤ 65

xx x 2B + xx x

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by jam007 on Tue, 2013-09-03 22:53
teacher rated 73 times
4.863015
purchased one time
price: $10.00

Solution to "Stateline Shipping and Transport Company from jam007

body preview (4 words)

Please xxx xxx xxxxxxxxxx

file1.doc preview (1765 words)

(1) xxxxxxxx xxxxxxxx

The problem xxx xx xxxxxxxx xx x Transportation problem xxx cost xxxxxxxxxxxxx The problem is xxxx xxx xxxxxxx xxx six xxxxxxxxxx centres from xxxxx xxxxxxx xxxxx to xxxxxxx xxxxx xxx then transported to xxxxx xxxxxxxxxx centres at a xxxxxxx xxxxx The xxxxxxxxx costs from collection xxxxxxx to xxxxxxxxxx xxxxx xxx given in a table as xxxxx xx the following xxxxxxx

xxxxxxxxxxxxxxxxx

xxxxx xxxxx

xxx xxxxx

Duras

Availability (bbl)

xxxxxxxxx

$12.00

xxxxxx

$17.00

xx

xxxxxxxx

xxxxxx

xxxxx

xxxxxx

26

xxxxx

xxxxxx

$20.00

xxxxxx

42

xxxxx

xxxxxx

xxxxxx

xxxxxx

xx

xxxxxxxx

xxxxx

xxxxxx

xxxxxx

29

xxxxxxxxx

$22.00

$16.00

xxxxxx

38

xxxxxxxx (barrels)

65

xx

105

Model xx the xxxxxxxxxxxx form:

xxx Xij xxxxxxxxxxxxxx xxxxxxx denote the quantity of waste xxxxxxxxxxx xxxx i-th plant to j-th xxxxx disposal centre. xxx xxxxxxxxx xxxxxxxx Z and constraints can xx expressed xxx

Minimize

- - - more text follows - - -

file2.xlsx preview (210 words)

xxxxxxxx xxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxX12 xxxxxx X22 X23xxxxxx X33xxxX42X43 X51 X52X53 xxx X62X63xxxSignRHS
Minimize12 xxxx14 x 10 13xx xx1716xx xxx12 22xx 18
Kingspor1 x1 35 x xx
xxxxxxxx x 1126=26
Macon1x x 42 x42
xxxxxx 1 x 53 = xx
Columbu 1 1 129xxx
Allentow 111 38 = 38
xxxxxxxxxxx11 x x x xx<= xx
Los xxxxx11 1 xx 179.9999999385 <x xx
Duras x1x 11 x78.0000000615<=xxx
Solution35 0x0 x xxx0 421 xx0 29 x x0 27.9999999385 xxxxxxxxxxxxx2822.0000001229
Z
WhitewaterLos xxxxx DurasAvailability (bbl)
xxxxxxxxxxx15 17xx
Danville14x xx26
Macon xxxx1142
xxxxx 17 16 xx xx
xxxxxxxx x14 12xx
Allentown 2216 xx xx
Capacity xxxxxxxxx 65 80 xxx

xxxxxxxx

- - - more text follows - - -


Buy this answer

Try it before you buy it
Check plagiarism for $2.00