I just need help with the set up of this problem, that's where I'm getting lost.

A mining company operates two coal mines, M1 and M2. The company sells the coal to three purchasers: two steel mills P1 and P2, and a power generating station P3. The cost of transporting a ton of coal from each mine to each purchaser is given in the following table:

P1 P2 P3
M1 50 45 50
M2 45 50 55

Suppose purchasers P1, P2, and P3, require at least 1000 tons, 1500 tons, and 1200 tons respectively. How many tons should be shipped from each mine to purchaser to minimize total cost while satisfying the purchaser's requirements?

SO! I need help with the set up from here. We need to do it in a tableaux and I can totally minimize it but I'm unsure of how to set up my equations. Thank you!

3 answers

Um... pretty sure this was a problem for one of my classes. Not supposed to be on the internet. Is there anyway to request to have a post removed?
There seems to be a problem here. I am reluctant to help with this linear programming problem under the circumstances.
Why don't you use Excel for this?