Reference no: EM132471713

Point 1: Coalco has three mines. Coal from the three mines is transported to a central location where it is processed (in a single production run, using coal from all three mines together), and shipped to four customers.

Point 2: The cost of producing coal, the ash and sulfur content per ton of coal, as well as the capacity of each mine and demand by each client are found in the worksheet. In addition, the cost of shipping from each mine to each client is also listed.

Point 3: Quality requirements are such that ash cannot make up more than 6% of the total coal shipped to each customer, and sulfur cannot make up more than 3.5% of the total coal shipped to each customer. Use Excel's Solver add-in to determine how to minimize the cost of meeting customer demands.

Question 1: Identity variables, objective, and constraints prior to solving with Excel's Solver.