Assignment 4: Transportation

Strayer University MAT540 Quantitative Methods Assignment 4: conveyance of backing 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 bespoke edition. Upper lodge River, New Jersey: Pearson/Prentice Hall. tick off the textbook problems for this subsidization have been modified.) 2.A paper manufacturing company hand overs rolls of newsprint to client in four cities (depicted below). Given the following transfer be, hire and supply, part Excel Solver to enter the marginal transportation cost to deliver the paper rolls demanded to the respective cities.

| | finish Transportation Cost ($) to: | | |Shipment | | | | | root Supply | |Origin (from) |Baltimore |battle of Atlanta |Chicago |New York |(rolls) | |Destination |10 |10 |10 |10 | | |Demand (rolls) | | | | | | 13.The Duff Beer play along has brewer! ies in Tampa and St. Louis. The 2 breweries supply beer to Tennessee (TN), Georgia (GA), North Carolina (NC), southward 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 play down 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, bless it on our website: OrderCustomPaper.com

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