Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

WebAssign For College Algebra Concepts And Contexts

Authors: James Stewart

1st Edition

1337772275, 9781337772273

More Books

Students also viewed these Mathematics questions

Question

The relevance of the information to the interpreter

Answered: 1 week ago

Question

The background knowledge of the interpreter

Answered: 1 week ago