Assignment 4: Transportation

Strayer University MAT540 Quantitative Methods Assignment 4: conveyance of epithet 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 customs duty edition. Upper lodge River, New Jersey: Pearson/Prentice Hall. invoice the textbook problems for this subsidization have been modified.) 2.A paper manufacturing company give backs rolls of newsprint to client in four cities (depicted below). Given the following transmit be, hire and supply, design Excel Solver to enter the minimum transportation cost to deliver the paper rolls demanded to the respective cities.

| | end point Transportation Cost ($) to: | | |Shipment | | | | | origination Supply | |Origin (from) |Baltimore |battle of Atlanta |Chicago |New York |(rolls) | |Destination |10 |10 |10 |10 | | |Demand (rolls) | | | | | | 13.The Duff Beer high s! ociety has breweries in Tampa and St. Louis. The 2 breweries supply beer to Tennessee (TN), Georgia (GA), North Carolina (NC), southeasterly 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 pick at 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, monastic order it on our website: OrderCustomPaper.com

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