Assignment 4: Transportation

253 Words2 Pages
Strayer University MAT540 – Quantitative Methods Assignment 4: Transportation Task: Using 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 Saddle River, New Jersey: Pearson/Prentice Hall. Note – the textbook problems for this assignment have been modified.) 2. A paper manufacturing company delivers rolls of newsprint to customer in four cities (depicted below). Given the following transportation costs, demand and supply, use Excel Solver to calculate the minimum transportation cost to deliver the paper rolls demanded to the respective cities. | |Destination Transportation Cost ($) to: | | |Shipment | | | | |Origin Supply | |Origin (from) |Baltimore |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 two breweries supply beer to Tennessee (TN), Georgia (GA), North Carolina (NC), South Carolina (SC), Kentucky (KT), and Virginia (VA) according to the monthly demand and transportation costs listed in the table below. To maximize 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

More about Assignment 4: Transportation

Open Document