Question: My excel SOLVER isnt working so I need help! A linear programming computer package is needed. per pound for Brazilian Natural and $ 0 .

My excel SOLVER isnt working so I need help!
A linear programming computer package is needed.
per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions of each coffee blend are as follows.
DeCaf, the production cost for the DeCaf blend is $1.05 per pound. Packaging costs for both products are $0.25 per pound.
Colombian beans purchased to produce DeCaf.)
Max
s.t.
Regular % constraint
DeCaf % constraint
Pounds of Regular
Pounds of DeCaf
(b) What is the optimal solution?
(BR,BD,CR,CD)=1
(c) What is the contribution to profit (in $)?(Round your answer to two decimal places.)
$
 My excel SOLVER isnt working so I need help! A linear

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!