Q1. Use the Simplex Method and Solver program? a) A branch of mining company plans to sell two types of GRANITE at costs of $250/ton and $400/ton, respectively. The $250/ton product yields a profit of $40 and the $400/ton product yields a profit of $55. The company estimates that the total monthly demand of Granite will not exceed 250 tons. Find the number of tons of each product that should be stocked in order to maximize the profit. Assume that the company does not want to invest more than $100,000 in this quarry.
Q1. Use the Simplex Method and Solver program? a) A branch of mining company plans to...
A branch of mining company plans to sell two types of GRANITE at costs of $250/ton and $400/ton, respectively. The $250/ton product yields a profit of $40 and the $400/ton product yields a profit of $55. The company estimates that the total monthly demand of Granite will not exceed 250 tons. Find the number of tons of each product that should be stocked in order to maximize the profit. Assume that the company does not want to invest more than...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...