Optimization Modeling Complete Questions And Detailed Answers/2024.

changing cells - correct answer a set of designated cells for the decision variables. the values in these changing cells can be changed to optimize the objective Two-way data table - correct answer allows you to see how a single output varies as two inputs vary simultaneously How does solver use whole numbers? - correct answer if you want solver to choose whole numbers for the decision variables, you need to add integer constraints allows you to see how a single output varies as two inputs vary simultaneously - correct answer Two-way data table Constraints have = or = - correct answer = or = what two things can go wrong in solver? - correct answer Infeasibility and unboundness infeasibility - correct answer either a mistake has been entered in the model or the problem has been constrained so many times there are no solutions left. can/should be fixed unboundness - correct answer the model can be made as large(or small) as you'd like ...if this occurs probably have entered a wrong input or forgotten some constraints ...this is a logical error b/c there is no realistic way a model can have an unbounded solution Absolute cell reference - correct answer the column & rows stay the same..$in front of the number and letter mixed cell reference - correct answer the column or row changes but one stays the same...for row to change $ in front of the letter...for the column to change $ in front of the number What is solver? - correct answer how much of each of its potential products to produce to maximize its net profit Product Mix What happens in optimization models? - correct answer Given a variety of numbers(the inputs) and are asked to make some decisions that optimize an objective while satisfying all constraints traditional solution method, write expressions using variables - correct answer make sure explicit constraints are added to ensure the x's are non negative algebraic model Graphical Solution - correct answer this approach only works with two decision variables Spreadsheet Model - correct answer Many ways to develop on. Common elements in all LP spreadsheets are inputs, changing cells, objective cell and constraints inputs - correct answer all numerical inputs that is given in the statement of the problem should appear somewhere on the spreadsheet changing cells - correct answer a set of designated cells for the decision variables. the values in these changing cells can be changed to optimize the objective objective cell - correct answer contains the value of the objective. solver systematically varies the values in the changing cells to optimize the value in the objective cell. this cell must be linked constraints - correct answer excel does not show constraints directly on the spreadsheet. instead they are specified in a solver dialog box net profit - correct answer unit margin *number to produce calculate total net profit - correct answer = SUMPRODUCT(B12:C12) How does solver use whole numbers? - correct answer if you want solver to choose whole numbers for the decision variables, you need to add integer constraints Two-way data table - correct answer allows you to see how a single output varies as two inputs vary si