make a table from given data
chocolate nuts | chocolate raisins | selling price per kg | |
one mixture = x1 | 1/2=0.5 | 1/2=0.5 | 7 |
second mixture = x2 | 3/4=0.75 | 1/4=0.25 | 9.5 |
total we have | 99 | 63 |
subject to
After introducing slack variables
subject to
Iteration-1 | Cj | 7 | 9.5 | 0 | 0 | ||
B | CB | XB | x1 | x2 | S1 | S2 | MinRatio XB/x2 |
S1 | 0 | 99 | 0.5 | (0.75) | 1 | 0 | 99/0.75=132→ |
S2 | 0 | 63 | 0.5 | 0.25 | 0 | 1 | 63/0.25=252 |
Z=0 | Zj | 0 | 0 | 0 | 0 | ||
Zj-Cj | -7 | -9.5↑ | 0 | 0 |
Negative minimum Zj-Cj is -9.5
and its column index is 2
Minimum ratio is 132 and its row index is 1.
The pivot element is 0.75.
Entering =x2, Departing =S1,
Iteration-2 | Cj | 7 | 9.5 | 0 | 0 | ||
B | CB | XB | x1 | x2 | S1 | S2 | MinRatio XB/x1 |
x2 | 9.5 | 132 | 0.6667 | 1 | 1.3333 | 0 | 132/0.6667=198 |
S2 | 0 | 30 | (0.3333) | 0 | -0.3333 | 1 | 30/0.3333=90→ |
Z=1254 | Zj | 6.3333 | 9.5 | 12.6667 | 0 | ||
Zj-Cj | -0.6667↑ | 0 | 12.6667 | 0 |
Negative minimum Zj-Cj is
-0.6667 and its column index is 1
Minimum ratio is 90 and its row index is 2.
The pivot element is 0.3333.
Entering =x1, Departing =S2
Iteration-3 | Cj | 7 | 9.5 | 0 | 0 | ||
B | CB | XB | x1 | x2 | S1 | S2 | MinRatio |
x2 | 9.5 | 72 | 0 | 1 | 2 | -2 | |
x1 | 7 | 90 | 1 | 0 | -1 | 3 | |
Z=1314 | Zj | 7 | 9.5 | 12 | 2 | ||
Zj-Cj | 0 | 0 | 12 | 2 |
Since all
Hence, optimal solution is arrived
.
.
.
the company should prepare 90 kg of first mix and 72 kg of the second mix for a maximum revenue of $1314
.
.
.
.
.
.
when second mix price is $11
subject to
Iteration-1 | Cj | 7 | 11 | 0 | 0 | ||
B | CB | XB | x1 | x2 | S1 | S2 | MinRatio XB/x2 |
S1 | 0 | 99 | 0.5 | (0.75) | 1 | 0 | 99/0.75=132→ |
S2 | 0 | 63 | 0.5 | 0.25 | 0 | 1 | 63/0.25=252 |
Z=0 | Zj | 0 | 0 | 0 | 0 | ||
Zj-Cj | -7 | -11↑ | 0 | 0 |
Negative minimum Zj-Cj is -11
and its column index is 2
Minimum ratio is 132 and its row index is 1.
The pivot element is 0.75.
Entering =x2, Departing =S1,
Iteration-2 | Cj | 7 | 11 | 0 | 0 | ||
B | CB | XB | x1 | x2 | S1 | S2 | MinRatio |
x2 | 11 | 132 | 0.6667 | 1 | 1.3333 | 0 | |
S2 | 0 | 30 | 0.3333 | 0 | -0.3333 | 1 | |
Z=1452 | Zj | 7.3333 | 11 | 14.6667 | 0 | ||
Zj-Cj | 0.3333 | 0 | 14.6667 | 0 |
Since all
Hence, optimal solution is arrive
.
.
the company should prepare 0 kg of first mix and 132 kg of the second mix for a maximum revenue of $1452
A candy company has 99 kg of chocolate-covered nuts and 63 kg of chocolate-covered raisins to be sold as two different mixes. One mix will contain half nuts and half raisins and will sell for $7 per...
A candy company has 123 kg of chocolate-covered nuts and 75 kg of chocolate-covered raisins to be sold as two different mixes. One mix will contain half nuts and half raisins and will sell for $7 per kg. The other mix will contain 3/4 nuts and 1/4 raisins and will sell for $9.50 per kg. complete parts a and b. a. How many kilograms of each mix should the company prepare for maximum revenue? find the maximum revenue. b. how...
A dairy company gets milk from two dairies and then blends the milk to get the desired amount of butterfat. Milk from dairy costs $2.40 per gallon, and milk from dairy II costs $0.80 per gallon. At most $144 is available for purchasing milk. Dairy I can supply at most 50 gallons averaging 3.9% butterfat, and dairy Il can supply at most 90 gallons averaging 2.9% butterfat. Answer parts a and b. a How much milk from each supplier should...
The Candy Company sells candy, nuts and raisins. They package their nuts and raisins together in 2 different ratio packs. One of their packs is 50% raisins and 50% nuts. The other mix is 25% raisins and 75% nuts. The price on the 50-50 mix is $7. The price on the 25-75 mix is $9.50. The current situation is that there are 114 kg of nuts and 82 kg of raisins. How should they package their nuts and raisins to...
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...