Here is the question:

Choose a three$-$dimensional LP maximization problem $(n-3)$ with two constraints $)=(2$ of your own choice. Solve the problem by using the Excel Solver. Change your problem if it does not have a feasible solution. Otherwise, generate the Solver Answer Report and record the number of simplex iterations and the computer execution time in that report. Remember to select Simplex LP as the Solver's solution method when solving the problem.e

Add another constraint to the existing constraints of the problem that you have chosen $)=(3.$ Repeat the steps described in #$1.$ You may change your problem whenever a feasible solution does not exist, but make sure that $n=3$ and $m=3$ in your problem.

Repeat the previous steps for $n=3$ and successive $m$ values of $m=4,5,$ and $6$ by successively adding a constraint to the current collection of constraints.

Plot the number of simplex iterations $($y$)$ versus the number of constraints $($m$).$ Save your plot as a picture file, and upload it in your discussion thread.

Plot the computer execution time $(t)$ versus the number of constraints $m.$ Save your plot as a picture file, and upload it in your discussion thread. $($Use four significant places after the decimal for $t.)$

Describe how the number of constraints and the required number of simplex iterations are related, according to your observations. Is this relation linear? Polynomial? Rational? Exponential? Furthermore, how are the number of constraints and the computer execution tim

$\backslash$table$[[,$M&M$\text{'}$s Sweetness total,M&M$\text{'}$s Color total,$],[x_R,3,300,2500],[$x$\_$G$,2,400,],[x_8,4,300,],[x_{-}y,5,400,405],[Nr,3,300,],[xp,4,200,],[,,,],[$Constraints$],[,,,1000],[,,,2000],[$Objective$,SBS25CS7,,],[,,,]]$

Please check my Solver information and please advise if I missed anythingI

Thanks in advance.e related? Is this relation linear?

I would like to do this on M&M$\text{'}$s$.$ Can you please help me set up Excel Solver and the graphs $($Number of Iterations vs Number of Constraints and Execution Time vs Number of Constraints$).$

MSMrs Production Madel

Let's define the problem with the following details:

Objective Function:

Maximize $z=3x+2y+4z$

Constraints:

Constraint $1$: $x+y10$

Constraint $2$: $2x+z<mn\; id="EditorElement\_298316">2</mn><mn\; id="EditorElement\_298317">0</mn>$

Additional Constraint for $m=3$:$x+y+zc=15[$for $m=3]$

I would like to do this on M&M$\text{'}$s$.$ Can you please help me set up Excel Solver and the graphs $($Number of Iterations vs Number of Constraints and Execution Time vs Number of Constraints$).$

M&M$\text{'}$s Production Madel

Let's define the problem with the following details:

Objective Function:

Maximize $z=3x+2y+4z$

Constraints:

Constraint $1$; $x+y10$

Constraint $2$: $2x+z=20$

Additional Constraint for $m=3$:$x+y+z=15($for $m=3).$ Am I on the right path in solving this? Thanks for your advice.