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, 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 firstStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
