Concept explainers
To explain: The reason why some other value or formula are not placed in the cells and what would be the difference if it is done so.
Explanation of Solution
Generally, it is immaterial of what is placed in the changing variable cells. The use of solver will ultimately determine the optimal value for the concerned cells automatically. It is the general principle used in linear optimization problems.
But in nonlinear optimization problems, there is an exception where the values placed in the changing variable cells represent the initial starting points for the optimizer. Apart from this, there is no difference between placing a value or some other formula in the changing variable cells.
Want to see more full solutions like this?
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,