Assignment 4: Transportation

Strayer University MAT540 Quantitative Methods Assignment 4: conveyance of rubric 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. banknote the textbook problems for this subsidization have been modified.) 2.A paper manufacturing company endures rolls of newspaper to client in four cities (depicted below). Given the following embark be, hire and supply, engagement Excel Solver to enter the token(prenominal) transportation cost to deliver the paper rolls demanded to the respective cities.

| | destination Transportation Cost ($) to: | | |Shipment | | | | | inventory Supply | |Origin (from) |Baltimore |battle of Atlanta |Chicago |New York |(rolls) | |Destination |10 |10 |10 |10 | | |Demand (rolls) | | | | | | 13.The Duff Bee! r family has breweries in Tampa and St. Louis. The 2 breweries supply beer to Tennessee (TN), Georgia (GA), North Carolina (NC), southmost 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 minify 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, assign it on our website: OrderCustomPaper.com

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