Introduction to Management Science A Modeling And Case Studies Approach with Spreadsheets 6th Edition By Frederick Hillier – Test Bank

Introduction to Management Science A Modeling And Case Studies Approach with Spreadsheets 6th Edition By Frederick Hillier – Test Bank

Intro to Management Science: Modeling and Case Studies, 6e (Hillier)
Chapter 8 Nonlinear Programming

1) Linear programming assumes that the profit from each activity is proportional to the level of that activity.

2) If the slope of a graph never increases but sometimes decreases as the level of the activity increases, then it is said to have decreasing marginal returns.

3) In problems where the objective is to minimize the total cost of the activities, an activity is said to have decreasing marginal returns if the slope of its cost graph never increases but sometimes decreases as the level of the activity increases.

4) If C1:C6 are all changing cells, then SUMPRODUCT(C1:C3, C4:C6) is a linear function.

5) If C1 is a changing cell, then ROUND(C1) is a linear function.

6) If D1 is a data cell, and C1 and C2 are changing cells, then IF(D1 >= 2, C1, C2) is a linear function.

7) Nonlinear programming problems with decreasing marginal returns are generally easier to solve then nonlinear programming problems with increasing marginal returns.

8) Sometimes the Solver can return different solutions when optimizing a nonlinear programming problem.

9) Excel’s curve fitting method is used to graph a nonlinear equation.

10) Excel’s curve fitting method is used to find the values of the parameters for an equation that best fit data.

11) A local maximum is always a global maximum in a nonlinear programming problem.

12) A quadratic programming problem is a special type of linear programming problem.

13) Having activities with decreasing marginal returns is the only way that the proportionality assumption can be violated.

14) Separable programming is applicable when there are increasing or decreasing marginal returns.

15) In separable programming, each activity that violates the proportionality assumption is separated into parts with a new variable for each part.