the Heartland Bread and Cereal Company, located in Chicago, St. Louis, and Cincinnati. Grain is shipped to the mills in railroad cars. Each grain elevator is able to supply the following tons ofgrain to the mills on a monthly basis: Each mill demands the following tons of wheat per month: The cost of transporting one ton of wheat from each grain elevator (source) to each mill(destination) differs according to the distance and rail system. These costs are shown next. For example, the cost of shipping 1 ton of wheat from the grain elevator at Omaha to the mill at Chicago is $7. Solve using Excel the number of tons of wheat to transport from each grain elevator to each mill on a monthly basis to minimize the total cost of transportation. Explain your answer.
Fig: 1
Fig: 2
Fig: 3
Fig: 4
Fig: 5
Fig: 6