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
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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