Question

Problem A-2 Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 2 decimal places.) Minimize 2 = 7A + 6B. 3A + 9B 2 70 Resource X 2A + 13B 234 Resource Y 4B 2 15 Resource Z Decision for A Decision for B Total cost Resources Used Resource X Resource Y Resource Z

Answer 1

We solve the given problem using excel solver as shown below:

Variables A 0 B 7.78 Objective Min Z 46.67 Condition Constraints 1 >= 70 70 101.11 31.11 Resource X Resource Y Resource Z 34 15 N 3

The above solution in the form of formulas along with Excel Solver extract is shown below for better understanding and reference:

B C D E G H — j F Solver Parameters 0 7.7777777777 A 1 Variables 2 А 3 B 4 5 Objective 6 Min Z 7 8 Constraints Set objective: $B$6 1 To: O Max O Min O Value of: =7*B2+6*B3 Condition By Changing Variable Cells: $B$2:$B$3 1 9 1 =3*B2+9*B3 =2*B2+13*B3 >= 70 Resource X 34 Resource Y 15 Resource Z Subject to the Constraints: $B$9:$B$11 >= $D$9:$D$11 =4*B3 >= Add Change Delete Reset All Load/Save 10 2 11 3 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Make Unconstrained variables Non-Negative Select a Solving Method: Simplex LP 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

Hence, we get answers as:

Decision for A = 0

Decision for B = 7.78

Total Cost = 46.67

Resource used

Resource X = 70

Resource Y = 101.11

Resource Z = 31.11

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!