# Flexible Transportation Problem Solver, including MAT 540 Week 10 Solutions

Feb 3rd, 2012
Studypool Tutor
Strayer University
Price: \$10 USD

Tutor description

Four sheets in an interactive, fully described excel workbook, dedicated to solving each of the four questions in this Week 10 assignment. Input numbers can be changed and the solution recalculated, so this can be used for transportation and traveling salesman problems in general. Being able to see the solution laid out, and how the sheet gets there, helps you understand both the concept and solution. Full instructions included, including screenshots of solver settings to be used.

Word Count: 712
Showing Page: 1/12
Complete (flexible!) solutions to:Strayer MAT540 Quantitative MethodsWeek 10 HomeworkSheets answer the following questions. However, if the questions change, the values in each sheet (white boxes) can alsosolver run again. These sheets will allow you to solve any problem in the form given in these four questions. If your questioform (i.e. not simply different numbers), please contact Tutor Iain Harlow on Studypool.com (I will likely be able to produceQ1) Transportation problem with cost matrix:ABC1524TO24383357Dema nd8011060FROMSuppl y13070100This example solved using sheet Q1 (solution already in the yellow boxes). For any other 3x3 cost matrix, simply adjust thematrix of 9 white boxes), supply (1 column of 3 white boxes) and demand (1 row of 3 white boxes).Q2) Transportation problem with cost matrix:ABC1524TO2129243257Dema nd8011060FROMSuppl y13070100This example solved using sheet Q1 (solution already in the yellow boxes). For any other 3x3 cost matrix, simply adjust thematrix of 9 white boxes), supply (1 column of 3 white boxes) and demand (1 row of 3 white boxes).Q3) Products must move from Hamburg, Marseilles and Liverpool to warehouses in Norfolk, New York and Savannah.Then, they must also be moved to distribution centers in Dallas, St. Louis and Chicago. This is a 2-step transportationcosts, supply and demand (make sure these match your question; update the white boxes where neces

## Review from student

Studypool Student
" Wow this is really good.... didn't expect it. Sweet!!!! "

Type your question here (or upload an image)

1831 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors