File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri 12 ~ AI a Wrap Text General SI TIX Y 5 X Cut LECopy Format Painter Fill Paste Insert Delete Format Ideas B I U CA Sensitivity ==== Merge & Center $ - % Conditional Format as Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity B32 X fic A B D E F G H I J K L M N O P Q R S T U V w YA 1 Problem 4 #4. [20 points) Find the values of x, y, and z that maximizes function f(x,y,z) in the following equation using "solver. 2 3 4 max f(x,y,z) = x0.5.yo.270.2 5 6 7 8 9 Subject to 100 - 2x - 3y = 0 20- y - 4z = 0 10 11 12 Equation max f(x,y,z) = x0.5y.2 20.2 13 - Find the values of x, y, and z that maximize the function, f(x,y,z), using "Solver", while satisfying 2 condtions shown by "subject to". - I put 1 for x, y, and z, respective, as thier initial values that might not be the values that maximize the function. 14 15 Subject to 100 - 2x - 3y = 0 20 - y - 4z = 0 16 17 18 19 20 Z 1.00 f(x,y,z) 1.00 1.00 1.00 21 22 23 Constraint Constraint 2 95.00 15.00 24 25 26 27 28 29 30 31 32 Information P1 P2 P3 P4 + 8596 File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri 12 ~ AI a Wrap Text General SI TIX Y 5 X Cut LECopy Format Painter Fill Paste Insert Delete Format Ideas B I U CA Sensitivity ==== Merge & Center $ - % Conditional Format as Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity B32 X fic A B D E F G H I J K L M N O P Q R S T U V w YA 1 Problem 4 #4. [20 points) Find the values of x, y, and z that maximizes function f(x,y,z) in the following equation using "solver. 2 3 4 max f(x,y,z) = x0.5.yo.270.2 5 6 7 8 9 Subject to 100 - 2x - 3y = 0 20- y - 4z = 0 10 11 12 Equation max f(x,y,z) = x0.5y.2 20.2 13 - Find the values of x, y, and z that maximize the function, f(x,y,z), using "Solver", while satisfying 2 condtions shown by "subject to". - I put 1 for x, y, and z, respective, as thier initial values that might not be the values that maximize the function. 14 15 Subject to 100 - 2x - 3y = 0 20 - y - 4z = 0 16 17 18 19 20 Z 1.00 f(x,y,z) 1.00 1.00 1.00 21 22 23 Constraint Constraint 2 95.00 15.00 24 25 26 27 28 29 30 31 32 Information P1 P2 P3 P4 + 8596