Question: please solve this two questions and show me the excel of the second one. I will give the high rate! Leary Chemical manufactures three chemicals:


please solve this two questions and show me the excel of the second one. I will give the high rate!
Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $4 and yields 3 units of A, 1 of B, and 1 of C. Running process 2 for an hour costs $1 and produces 1 unit of A and 1 of B. To meet customer demands, at least 10 units of A, 5 of B, and 3 of C must be produced daily. Please determine a daily plan of running process 1 and 2 that minimizes the cost of meeting Leary Chemical's daily demands. 1. Please formulate the LP of this problem 2. Please use Excel to solve the LP and write down the optimal solution and optimal objective value (see the file ICE_2_Excel.xlsx attached) C14 X A B D E F H - K L 1 x1 x2 2 3 4 variables cost objective function 5 Directions: 1. Write the LP model in the spreadsheet and solve it in Solver 2. Keep the solver solution and submit the Excel file 6 7 sum of Left-hand side right-hand side 8 constraints 9 10 11 12 13 14 15 16 17Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
