Transporting Coal. The Calcio Coal Company produces coal at four mines and ships it to four power plants (P1-P4). The cost per ton of producing coal and the production capacity (in tons) for wach mine are known. The number of tons of each coal demanded by each customer is also known. The cost (in dollars) of shipping a ton of coal from a mine to each plant is available as well. The following table provides the data: P1P2P3P4CapacityCostMine 191581012550Mine 2715141210057Mine 355111215055Mine 43681112061Demands110115135130 a. Calcio wishes to minimize the cost of transporting coal from its mines to its plants. What is the minimum cost?b. What is the transportation schedule that achieves the minimum cost in (a)?Note:-Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure.

Answered: Transporting Coal. The Calcio Coal…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

Transporting Coal. The Calcio Coal Company produces coal at four mines and ships it to four power plants (P1-P4). The cost per ton of producing coal and the production capacity (in tons) for wach mine are known. The number of tons of each coal demanded by each customer is also known. The cost (in dollars) of shipping a ton of coal from a mine to each plant is available as well. The following table provides the data:

	P1	P2	P3	P4	Capacity	Cost
Mine 1	9	15	8	10	125	50
Mine 2	7	15	14	12	100	57
Mine 3	5	5	11	12	150	55
Mine 4	3	6	8	11	120	61
Demands	110	115	135	130

a. Calcio wishes to minimize the cost of transporting coal from its mines to its plants. What is the minimum cost?

b. What is the transportation schedule that achieves the minimum cost in (a)?

Note:-

Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 9 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions