E6 X =SUMPRODUCT(C5:05,C6:06) . B D E F G H - K M N O P O R S T U 1 Toronto Air Fresh 2 3 4 5 Chandeliers Variable: X1 Values 4 Profit 7 Fans X2 1 6 Total Profit 34 6 7 Constraints LHS Sign RHS Find the optimum combination of the quantity of X1 and X2. Solve for profit using solver. This is an integer model. Find the optimum combination of the quantity of X1 and X2. The quantity for X1 should be at least 2 and quantity for X2 should never be zero. Solve for profit using solver. This is an integer model. 9 Wiring hoy 2 0 12 3 5 Assembly hd 6 0 Vi vil 30 10 11 12 13 14 15 16 X1 X2 Total Profit X1 X2 Total Profit 17 Answer Answer 18 19 20 21 22 23 24 25 E6 X =SUMPRODUCT(C5:05,C6:06) . B D E F G H - K M N O P O R S T U 1 Toronto Air Fresh 2 3 4 5 Chandeliers Variable: X1 Values 4 Profit 7 Fans X2 1 6 Total Profit 34 6 7 Constraints LHS Sign RHS Find the optimum combination of the quantity of X1 and X2. Solve for profit using solver. This is an integer model. Find the optimum combination of the quantity of X1 and X2. The quantity for X1 should be at least 2 and quantity for X2 should never be zero. Solve for profit using solver. This is an integer model. 9 Wiring hoy 2 0 12 3 5 Assembly hd 6 0 Vi vil 30 10 11 12 13 14 15 16 X1 X2 Total Profit X1 X2 Total Profit 17 Answer Answer 18 19 20 21 22 23 24 25