Question: PLEASE SOLVE USING EXCEL! Colombian Mild. The compositions of each coffee blend are as follows. DeCaf blend is $ 1 . 0 5 per pound.

PLEASE SOLVE USING EXCEL!
Colombian Mild. The compositions of each coffee blend are as follows.
DeCaf blend is $1.05 per pound. Packaging costs for both products are $0.25 per pound.
produce DeCaf.)
Max
s.t.
Regular % constraint ,.25BR-.75CR=0
DeCaf % constraint ,.60BD-.40CD=0
Pounds of Regular
Pounds of DeCaf
BD+CD=300
(b) What is the optimal solution?
(BR,BD,CR,CD)=()
(c) What is the contribution to profit (in $)?(Round your answer to two decimal places.)
 PLEASE SOLVE USING EXCEL! Colombian Mild. The compositions of each coffee

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!