# 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”**

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

body preview (11 words)

xxx xxx Assignment x xxxx Problem “Stateline xxxxxxxx xxx Transport Company”

file1.xls preview (150 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Problem x x Stateline Shipping xxx Transport Company | |||||||||||

xxxxx | |||||||||||

Sites | Kingsport | Danville | xxxxx | Selma | Columbus | Allentown | xxxxxxxxxx | Los xxxxx | Duras | Supply | Shipped |

xxxxxxxxx | xxx | 16 | 19 | x | 0 | x | x | x | 0 | 285 | 285 |

xxxxxxxx | x | 196 | 0 | x | x | 0 | 0 | 80 | 0 | 276 | 276 |

Macon | 0 | x | 214 | x | x | 0 | x | 0 | 78 | 292 | 292 |

Selma | x | 0 | 17 | 250 | xx | x | x | x | x | 303 | xxx |

Columbus | x | x | x | 0 | xxx | x | xx | 0 | x | 279 | xxx |

xxxxxxxxx | 0 | xx | 0 | 0 | x | 250 | x | x | x | 288 | 288 |

xxxxxxxxxx | 0 | x | x | x | x | x | xxx | x | 0 | xxx | xxx |

Los Canos | 0 | 0 | 0 | x | x | x | x | xxx | x | 250 | xxx |

Duras | 0 | 0 | x | x | 0 | x | x | x | 250 | xxx | xxx |

Demand | xxx | xxx | xxx | 250 | 250 | xxx | 315 | xxx | 355 | ||

xxxxxxx | 250 | 250 | 250 | 250 | xxx | xxx | xxx | xxx | 328 | ||

Total Cost = | 2630.00 | ||||||||||

xxxxxxxx Costs xxxx | |||||||||||

xxxxx | |||||||||||

xxxxx | Kingsport | Danville | xxxxx | xxxxx | Columbus | Allentown | xxxxxxxxxx | xxx Canos | xxxxx | ||

xxxxxxxxx | 0 | x | 4 | 9 | x | 8 | xx | xx | xx | ||

xxxxxxxx | 6 | x | 11 | 10 | xx | 7 | xx | 9 | 10 | ||

Macon | 5 | 11 | x | 3 | x | xx | 13 | xx | 11 | ||

xxxxx | x | xx | x | x | x | xx | 17 | xx | 19 | ||

Columbus | x | xx | 7 | 3 | 0 | xx | x | 14 | xx | ||

Allentown | x | x | xx | xx | 14 | 0 | xx | xx | 18 | ||

xxxxxxxxxx | xx | 14 | xx | xx | x | xx | x | 12 | 10 | ||

Los xxxxx | xx | x | 20 | 16 | xx | 16 | 12 | x | 15 | ||

Duras | 17 | xx | xx | xx | xx | xx | 10 | 15 | x |

# xxxxxx

# Sheet3

file2.docx preview (915 words)

xxxx Problem “Stateline Shipping and Transport Company”

xxxxxxx Name:

Instructor:

College:

xxxxxxx

Date

**1. xxxxxxxxxxxxxx Model for shipping waste xxxxxxxx from xxx x xxxxxx xx the x xxxxx disposal xxxxxx**

In xxxxxxxx MS Excel xxxxxxxxxxx xxx table show xxx xxxx xx xxxxxxxx xxx xxxxxx of xxxxxx xxxx each xx xxx xxx xxxxxx xx xxxx xx xxx xxxxx waste disposal sites, together with xxxxxx of xxxxx xxxxxxxxx in the various xxxxxx xxx xxxxxxxx of xxx disposal xxxxxx

**2. Model was solved as follows:**

I. xxx xxx xxxxxx were labelled 1 through 6, while the three xxxxx xxxxxxxxxx labeled x through C.

II. xxxxxxxxx xxxxxxxxx xxxxxxxx x = xxxxxx + 1B(15) x xxxxxx + xxxxxx x xxxxx x xxxxxx + xxxxxx x 3B(20) + xxxxxx x xxxxxx + xxxxxx x 4C(19) x xxxxx x xxxxxx x 5C(12) x xxxxxx + xxxxxx x xxxxxxx

xxxx Subject xxx

1A + 1B x 1C = 35

xx x 2B x 2C x xx

xx x xx x xx = 42

xx + 4B + 4C = xx

xx + xx x xx = xx

6A x 6B x 6C x xx

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

xx x 2B x xx +

- - - more text follows - - -

Try it before you buy it |