Optimization Problems: Cost and Time
10 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of clicking 'Add' in the dialogue box?

  • To access the Excel Office Button
  • To restart Excel
  • To display the Solver Options
  • To display the add Constraint box (correct)

What is the purpose of the 'int' option in the add Constraint box?

  • To display the Solver Options
  • To restrict variables to non-negative values
  • To restrict variables to integer or binary values (correct)
  • To access the Excel Office Button

Why may the default precision of .000001 be problematic?

  • It may incorrectly return the message 'Solver found a feasible solution'
  • It may incorrectly return an infeasible solution
  • It may correctly return the message 'Solver found a feasible solution'
  • It may incorrectly return the message 'Solver could not find a feasible solution' (correct)

What is the purpose of checking 'Assume Linear Model' in the Solver Options?

<p>To assume a linear model with non-negative constraints (C)</p> Signup and view all the answers

What is the purpose of using descriptive Excel range names?

<p>To enhance readability (B)</p> Signup and view all the answers

What happens if the default precision is too 'high'?

<p>Solver returns the message 'Solver could not find a feasible solution' (D)</p> Signup and view all the answers

What is the purpose of the 'bin' option in the add Constraint box?

<p>To restrict variables to binary values (B)</p> Signup and view all the answers

Why may the problem be infeasible?

<p>The problem is incorrectly defined (C)</p> Signup and view all the answers

What must be specified if the default precision is too 'high'?

<p>Less precision (i.e., a larger value) (D)</p> Signup and view all the answers

What should be done if Solver does not appear under the Data menu?

<p>Click Excel Office Button &gt; Excel Options &gt; Add-ins &gt; Solver Add-in &gt; OK (D)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser