Question: Can you help me understand how to properly solve this MS excel question for the SOLVER feature? I have attached the solution on the left.

Can you help me understand how to properly solve this MS excel question for the SOLVER feature?

I have attached the solution on the left. I circle in a red box what I do not understand. To the right is my attached attempt to solve via solver yet did not work out need help.

Can you help me understand how to properly solve this MS excel

Decision Variables X1 X2 X3 A B C D E F G H J K L M N Objective Function Decision Variables XI X2 X3 Z = Max( 95*X1+40*X2+90*X3) 2 Classic A Sling D Hamm 3 Cutting 2 hour 1/2 hour 6/10 hour Solver Parameters X Constraints Assembly 2 hour 3/4 hour 2 hour 2*X1+1/2*X2+6/10*X3 30 Set Objective: SO$10 2*X1+3/4*X2+2*X3 50 5 Finishing 1 hour 1 hour 1 hour A 5*X1+9/4*X2+36/10*X3 125 16 Totals 5 hours 2.25 3.6 TO: Max O value of: Solution: By Changing Variable Cells 8 $C$1:50$2 Payoff:- 95 40 90 19 Objective Function Subject to the Constraints: DV:- X1 X2 X3 10 Total 2475 1 37 10 SBS3:SD$3 = $8$17:50$17 Cutting 2.00 0.50 0.60 Assembly 2.00 0.75 2.00 13 Constaints Delete Finishing 1.00 1.00 1.00 14 26.5 = 50 21 Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex 50 engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are 22 non-smooth. So below is the number of chair he should produce and optimal profit would be 2475 23 Help Solve Close Classic A Siling D Hamm 24 37 10 25 If we increase the finishing hours and now try to solve the equestion with change two constriaines which are given below: X1 + X2 +X3 >= 50 (Since finishing hours have increased) 2*X1+3/4*X2+2*X3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!