Question: You are to create a least cost shipping schedule between plants (Seattle, San Diego), middlemen (Pittsburgh, Cincinnati) and markets (New York, Chicago, Topeka). The available

  • You are to create a least cost shipping schedule between plants (Seattle, San Diego), middlemen (Pittsburgh, Cincinnati) and markets (New York, Chicago, Topeka).
  • The available supply in 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, middlemen, and markets is:

You are to create a least cost shipping schedule

Build an Excel Solver model to find the optimal solution.

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

325 0.7 New York 350 1.2 Seattle Pittsburgh 0.9 1.4 0.9 300 1.8 Chicago 0.4 600 San Diego Cincinnati 1.5 1.6 275 1.4 Topeka

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!

Q:

On 6/1/17, an American firm purchased an inventory costing 100,000 Canadian Dollars from a Canadian firm to be paid for on 8/1/17. Also on 6/1/17, the American firm entered into a forward contract to...

Q:

Create a least cost shipping schedule between plants (Seattle, San Diego), middlemen (Pittsburgh, Cincinnati) and markets (New York, Chicago, Topeka). The available supply in Seattle 350 units, San...

Q:

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

Q:

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

Q:

You are to create 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...

Q:

Generate a summary scenario utilizing the seasonal sales forecasts. Utilize the scenario manager to craft a professional summary page encompassing the Black Friday, Post - Holiday Season, and Summer...

Q:

Problem # 3 Imagine you're managing the shipment of goods from two plants ( Seattle and San Diego ) to three markets ( New York, Chicago, and Topeka ) . The goal is to figure out the best way to ship...

Q:

Problem # 3 Imagine you're managing the shipment of goods from two plants ( Seattle and San Diego ) to three markets ( New York, Chicago, and Topeka ) . The goal is to figure out the best way to ship...

Q:

Problem # 3 Imagine you're managing the shipment of goods from two plants ( Seattle and San Diego ) to three markets ( New York, Chicago, and Topeka ) . The goal is to figure out the best way to ship...

Q:

Problem # 3 Imagine you're managing the shipment of goods from two plants ( Seattle and San Diego ) to three markets ( New York, Chicago, and Topeka ) . The goal is to figure out the best way to ship...

Q:

I need this solution on EXCEL. Thank you. 3-1. This transportation model, which deals with finding a least cost shipping schedule, comes from Dantzig's Linear Programming and Extensions. A company...

Q:

Show the relationship of the vertical, horizontal and profile planes of first-angle projection by means of a sketch. [3]

Q:

Does a callable bond exhibit negative or positive convexity?

Q:

Indicate the effect of the transactions listed below on each of the following: working capital, current ratio, debt ratio, net income, and stockholders' equity. Use + to indicate an increase, to...

Q:

Two firms must simultaneously choose their prices, setting either pH or p1. Suppose payoffs are given by the values in the table below. Firm 2 PH PL PM 20 30 20 0 Firm 1 0 15 PL 30 15 (a) Determine...