Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
bartleby

Concept explainers

Question
Book Icon
Chapter 3, Problem 1QP
Summary Introduction

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.

Expert Solution & Answer
Check Mark

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Background pattern image
Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,