Total Cost of Looking-Changed Cells Obtained: Three Valves Formulas Cost Calculation Formula Objective, Min. Two Restrictions is clrarly show below with excel file worksheet.
Set up the excel file as above, use fraction instead of percentage for ease in calculation.
Calculating the amount of each type valve
Formula for Values obtained in B16 is '=SUMPRODUCT(C3:C5,B9:B11)'
Formula for Values obtained in C16 is '=SUMPRODUCT(D3:D5,B9:B11)'
Formula for Values obtained in D16 is '=SUMPRODUCT(E3:E5,B9:B11)'
Calculating total Cost
in B22 formula used is =B9*B3+B10*B4+B11*B5
In B9, B10 and B11, initialize values to zero..
Now, go to solver and add these constraints and objective function:
in Set Objective select the Total cost cell.
Select Min instead of Max. since you want to minimize cost
Solving method: Select Simplex LP
Learn more about excel file here:
https://brainly.com/question/5450162
#SPJ4