Homework 4 - 8-1-18 (1).docx - Autumn Lamb MGMT 651 –...

This preview shows page 1 - 5 out of 11 pages.

The preview shows page 3 - 5 out of 11 pages.
Autumn LambMGMT 651 – Analytics for Managerial Decision-MakingHomework 4Worth 100 pointsDO NOT FORGET TO TYPE YOUR NAME ON THE FIRST PAGE OF YOUR HOMEWORK SUBMISSION DOCUMENTPart I1.(15 points) Chapter 6 Problem 2a) X11= amount shipped from Jefferson City to Des MoinesX12= amount shipped from Jefferson City to Kansas CityX13 = amount shipped from Jefferson City to St. LouisX21 = amount shipped from Omaha to Des MoinesX22 = amount shipped from Omaha to Kansa CityX23 amount shipped from Omaha to St. LouisMin 14X11 + 9X12 + 7X13 + 8X21 + 10X22 + 5X23ConstraintsX11 + X12 + X13 =< 30X21 + X22 + X23 =< 20X11 + X21 = 25X12 + X22 = 15X13 + X23 = 10X11, X12, X13, X21, X22, X23 >= 0b) Optimal Solution : Transportation Cost: $435Jefferson City – Des Moines570Jefferson City – Kansas City15135Jefferson City – St. Louis1070Omaha – Des Moines20160Submit your homework as one single attachment. Include POM-QM input and output screenshots whereverapplicable.If you submit your homework as an MS-Excel document, make sure that it is properlyformatted to 8.5x11 page size!!1of11
Autumn Lamb2.(15 points) Chapter 6 Problem 3a)b)X11 = amount shipped from Southern to HamiltonX12 = amount shipped from Southern to ButlerX13 = amount shipped from Southern to ClermontX21 = amount shipped from Northwest to HamiltonX22 = amount shipped from Northwest to HamiltonX23 = amount shipped from Northwest to ClermontMin 10X11 + 20X12 + 15X13 + 12X22 + 18X23ConstraintsX11 + X12 + X13 =< 500X21 + X22 + X23 =< 400X11 + X21 = 400X12 + X22 = 200X13 + X23 = 300X11, X12, X13, X21, X22, X23 >= 0Southern – Hamilton2002000Southern - Clermont3004500Northwest – Hamilton2002400Northwest – Butler2003000Total Cost11,900c)Total Distribution Cost : $11,900Submit your homework as one single attachment. Include POM-QM input and output screenshots whereverapplicable.If you submit your homework as an MS-Excel document, make sure that it is properlyformatted to 8.5x11 page size!!2of11
Autumn Lambd)X12 + X22 = 300. With the increase in demand, our table shows that Tri-County shouldgowith Northwest for maximum optimization.Submit your homework as one single attachment. Include POM-QM input and output screenshots whereverapplicable.If you submit your homework as an MS-Excel document, make sure that it is properlyformatted to 8.5x11 page size!!3of11
Autumn Lamb3.(15 points) Chapter 6 Problem 11a)Submit your homework as one single attachment. Include POM-QM input and output screenshots whereverapplicable.If you submit your homework as an MS-Excel document, make sure that it is properlyformatted to 8.5x11 page size!!

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 11 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture