Question: Please show: Decision variables, coefficients, constraints, objective function, etc. by using the Excel linear programming solver and the SUMPRODUCT function. Please help ASAP, thank you

Please show: Decision variables, coefficients,

Please show: Decision variables, coefficients, constraints, objective function, etc. by using the Excel linear programming solver and the SUMPRODUCT function. Please help ASAP, thank you so much!

Master Coffee Roasters blends coffee for its customers. It sells three blends in one-pound bags: Dreamy Dark, Master Medium, and Light Lift. It uses coffee from four different sources to produce the blends: Brazilian, Columbian, Indonesian, and Ethiopian. The shop uses the following recipes for the blends: Blend Mix Requirements Selling Price/lb Dreamy Dark $10.45 50% Columbian 50% Ethiopian Master Medium $11.20 40% Indonesian 40% Brazilian 20% Ethiopian Light Lift $12.70 60% Ethiopian 40% Brazilian The costs for the four different source coffees are as follows: Brazilian Columbian $3.40 per pound $4.15 per pound Indonesian $5.55 per pound Ethiopian $2.90 per pound For the upcoming week the shop has 115 pounds of Brazilian, 95 pounds of Columbian, 80 pounds of Indonesian, and 140 pounds of Ethiopian coffee. How much of each blend should the shop prepare in order to maximize profit (assuming they sell all of the coffee they blend), and what will their profit be? HINT: Calculate the profit for each blend first

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!