Use Excel Solver to a Transportation Problem

Problem 6: Transportation Problem. Remember, these days packages from Amazon are coming from all over the US. How you ever wonder why this thing is coming from this city?
A company has two warehouses in Seattle and San Diego which supply products to cities with demand. This include New York, Chicago, and Topeka. The following table show the distance between these cities in thousands of miles. The shipping truck cost per mile is 5.8 cents.
Currently, here is a breakdown of supply and demand.
Supplies
s1 Seattle 325
s2 San Diego 575

Demands
d1 New York 325
d2 Chicago 300
d3 Topeka 275
Use the Excel Solver to find the optimal flow of goods between supply and demand cities to have a minimum shipping cost.

[omparkashkaushik]

Thank you for sharing best information 👍