Chapter 08 – 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.
Chapter 08 – Nonlinear Programming
Multiple Choice Questions
36. If the data cells are in column D and the changing cells are in column C, which of the
following are linear formulas in a spreadsheet?
37. If the data cells are in column D and the changing cells are in column C, which of the
following are not linear formulas in a spreadsheet?
38. When there are decreasing marginal returns:
39. Decreasing marginal returns violates which assumption of linear programming?
