ONLY IN EXCEL PLEASE AND THANK YOU !! can somebody please explain how to do the Q1b please, how did they get the 'intege

[answerhappygod]

ONLY IN EXCEL PLEASE AND THANK YOU !!
can somebody please explain how to do the Q1b please,
how did they get the 'integer' thing on the solver? (please show me
how to do all the steps, im so lost)

Only In Excel Please And Thank You Can Somebody Please Explain How To Do The Q1b Please How Did They Get The Intege 1 (202.89 KiB) Viewed 40 times

A 3 5 bj. function 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 3.8 39 40 1 2 B Min production req. Profit Mahogany Pine Carpenter Chairs req. Balance req. C E Decision Variables Closets Tables Chairs $400 $300 $80 2.5 1.5 1 1 2 3 5 3 4 4 -1 1 -1 Answer: Chairs (6 ponits) Tables Closets Profit Answer (4 points) Why? D F $ $ LHS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 H I RHS 300 350 600 0 0 J Max production 65 K L M N 0 P Q R 5 T Q1.b. Suppose that Woodworks Industries Inc. has decided not to accept decimals numbers for decision variables and has asked for integer (whole) values for decision variables. Does this assumption change the optimal solution? Why? Carpenter hours Mahogany (units) Pine (units) 2.5 1 5 Closet set Table set 1.5 2 3 Chairs set 1 3 4 Available 300 350 600
2 From From From From Other Access Web Text Sources Get External Data G5 A B 1 4 Min Production req 5 Obj function Profit 6 7 Constraints 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 3 Existing Connections C Mahogany Pine Carpenter Chair req Balance req Refresh All Connections Properties Edit Links Connections D Closet E Decision variables 400 2.5 1 5 2 22 Sort 1 F Table Chairs 300 1.5 2 3 4 -1 Answer: C T O Profit Filter Sort & Filter G 80 1 3 4 -1 LHS Clear Reapply Advanced H 0 <= 0 <= 0 <= 0 <= 0 = 0 0 0 0 Text to Remove Columns Duplicates Validation Data Too I J Max prodcution 35 RHS 300 350 600 0 0 Data Solver Parameters Set Objective: To: Ⓒ Max By Changing Variable Cells: $D$4:$F$4 Subject to the Constraints: $D$4<= $J$3 $D$4 = integer $E$4<= $J$3 Add Change $E$4 = integer $F$4<= $1$3 $F$4 = integer $G$10 <= $I$10 $G$11 <= $I$11 $G$12 = $I$12 $G$8 <= $1$8 Delete Reset All Load/Save $G$9 <= $1$9 Make Unconstrained Variables Non-Negative Select a Solving Method: GRG Nonlinear Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close $G$5 Show Detail ? Solver 0 O Min O Value Of: EN X