Question: Assignment 2.1 You are to create a least cost shipping schedule between plants (Seattle, San Diego) and markets (New York, Chicago, Topeka). The available supply
Assignment 2.1
- You are to create a least cost shipping schedule between plants (Seattle, San Diego) and markets (New York, Chicago, Topeka).
- The available supply is Seattle 350 units, San Diego 600 units.
- The demand is New York 325 units, Chicago 300 units, Topeka 275 units.
- The cost to ship between plants and markets is:
| New York | Chicago | Topeka | |
| Seattle | 2.5 | 1.7 | 1.8 |
| San Diego | 2.5 | 1.8 | 1.4 |
- Assignment 2.1, Part 1: The first task is to create a "word" formulation for this problem. Upload it to Assignment 2.1, Part 1 Drop Box as a PDF. Due at the end of Week 3
- Assignment 2.1, Part 2: The second task is to build an Excel Solver model to find the optimal solution. Upload the Excel file to the Assignment 2.1, Part 2 Drop Box. Due at the end of Week 3
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
