Question: 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

  • 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.

*Please provide step by step instructions on how to do this in Solver. Thank you*

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!