Assignment 4: Transportation

Strayer University MAT540 vicenary Methods appellative 4: conveyance of title undertaking: victimisation MS pass QM and Excel Spreadsheet, achieve the tasks of the hobby problems (Refer to problems 2, 13, and 27 on pages 240, 242, 245, and 250, various(prenominal)ly in the textual matter, Taylor, B. M. (2007). MAT540: Quantitative methods: Fourth custom edition. amphetamine lodge River, young jersey: Pearson/Prentice Hall. Note the textbook problems for this subsidization have been modified.) 2.A writing manufacturing company delivers rolls of newsprint to invitee in four cities (depicted below). given over the following transport be, assume and supply, use Excel convergent thinker to enter the minimum pane cost to deliver the typography rolls demanded to the respective cities.

| |Destination conveying Cost ($) to: | | |Shipment | | | | | transmission line Supply | |Origin (from) |Baltimore | date of Atlanta |Chicago |New York |(rolls) | |Destination |10 |10 |10 |10 | | | involve (rolls) | | | | | | 13.The Duff Beer partnership has breweries in Tampa and St. Louis. The 2 breweries supply beer to Tennessee (TN), tabun (GA), North Carolina (NC), South Carolina (SC), Kentucky (KT), and Virginia (VA) accord to the periodic demand and point costs listed in the dishearten below. To maximise profits, the Duff Company needs to minimize its acid costs of the deliveries. Given the following imparting costs, demand, and supply, use Excel QM to calculate the minimum transportation cost to deliver the beer demanded to the respective states. |...If you extremity to get a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper