Question: Basis: To solve this linear programming problem, we must formulate the objective function and constraints based on each chemical compound's specifications and cost per pound.
Basis: To solve this linear programming problem, we must formulate the objective function and constraints based on each chemical compound's specifications and cost per pound. Then, we can use Excel's Solver tool to find the optimal solution. Objective Function: Minimize Cost = 0.12 * C-30 0.09 * C-92 0.11 * D-21 0.04 * E-11 Constraints: Chemical E-11 must comprise at least 15% of the blend: E-11 >= 0.15 * (C-30 C-92 D-21 E-11) C-92 and C-30 must together constitute at least 45% of the blend: C-92 C-30 >= 0.45 * (C-30 C-92 D-21 E-11) D-21 and C-92 can together constitute no more than 30% of the blend: D-21 C-92
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
