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

• 11
• 100% (1) 1 out of 1 people found this document helpful

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

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 11 pages?