Assignment 4: Transportation

Strayer University

MAT540 Quantitative Methods

Assignment 4: conveyance of title

Task:

victimisation MSExcel QM and Excel Spreadsheet, perform the tasks of the following problems (Refer to problems 2, 13, and 27 on pages 240, 242, 245, and 250, respectively in the textbook, Taylor, B. M. (2007). MAT540: Quantitative methods: Fourth custom edition. Upper lodge River, New Jersey: Pearson/Prentice Hall. Note the textbook problems for this subsidization have been modified.)



2.A paper manufacturing company delivers rolls of newsprint to client in four cities (depicted below). Given the following transport be, hire and supply, use Excel Solver to enter the minimum transportation cost to deliver the paper rolls demanded to the respective cities.





| |Destination Transportation Cost ($) to: | |
|Shipment | | | | |Origin Supply |
|Origin (from) |Baltimore |battle of Atlanta |Chicago |New York |(rolls) |
|Destination |10 |10 |10 |10 | |
|Demand (rolls) | | | | | |


13.The Duff Beer Company has breweries in Tampa and St. Louis. The 2 breweries supply beer to Tennessee (TN), Georgia (GA), North Carolina (NC), South Carolina (SC), Kentucky (KT), and Virginia (VA) according to the periodic demand and transportation costs listed in the table below. To maximise profits, the Duff Company needs to minimize its transportation costs of the deliveries. Given the following transportation 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: Orderessay



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